MySQL Tutorial MySQL Utilities 49 codes

1 Automatically drop any tables that exist before restoring the stored tables with the --add-drop-table

2 Continue even if errors in batch mode, you should use the --force command-line option

3 Create the database if it doesnt already exist with --databases option to specify the database we wish to back up

4 Delay an INSERT statement until the table is no longer in use

5 Display all table names

6 Execute an UPDATE statement when no one else is using the table

7 Exporting Data

8 If anonymous (unnamed) user is allowed, you should be able to connect to that server by invoking mysql without any options

9 If you are logging in on the same machine that MySQL is running on, you can omit the host

10 If you need to specify connection parameters on the command line in batch mode

11 Importing data

12 LOAD DATA INFILE into a table

13 Load data to your table

14 Logging In with mysql

15 Mysqldump

16 Mysqlhotcopy

17 Mysqlimport

18 Non-Interactive Commands

19 Optimising a dump

20 Remote Client Connection

21 Restoring a Dump

22 Run the output through a pager

23 Select into a DUMPFILE

24 Select into a file with starter

25 Select into a file with terminator and encloser

26 Select into a file with terminator, encloser and Escaper

27 Select into a file with where clause

28 Select into with Line and field separator

29 Show a detailed listing of the columns of your database

30 SHOW COLUMNS and DESCRIBE can display information about the columns in individual INFORMATION_SCHEMA tables

31 SHOW CREATE TABLE statement

32 SHOW INDEX FROM tbl_name

33 SHOW WARNINGS

34 Supply your password on the command line after the -p option

35 To escape some special characters in the file

36 To force MySQL to perform the SELECT first

37 To have a DELETE statement execute while no one else is reading from the table

38 To make a copy of live data

39 To see a list of options provided by mysql, invoke it with the --help option

40 To see the structure or schema of a database

41 Turn Exporting and Importing Data on

42 Use scripts from the mysql prompt by using the source command or command

43 Use the SHOW statement to find out what databases currently exist on the server

44 Using a STATUS command

45 Using mysql in Batch Mode

46 Using mysqldump to copy databases

47 You can catch the output in a file for further processing

48 You can disconnect any time by typing QUIT (or q) at the mysql prompt

49 You can select the database on the command line when you invoke mysql