MySQL large Database Import and Export script

When using the MySQL database, if you import data frequently. To export the entire database using MySQL Internal commands, it is often because a table fails, resulting in the entire Import and Export job failure. So I want to divide and conquer it. Use PHP to write a script. Each import/export operation has a higher chance of success.
Use:

Usage: PhP dbio. php IM/import/EX/export/TR/truncate DB: // User: password @ host/dat
Abase path [-N]
Im/import is import DB from SQL files which is exists;
EX/export is export dB to SQL files;
TR/truncate is empties all tables in this database; the parm 'path' will be
Ignored. Path: the directory of the SQL files;
[-N] is optional parameter just for create new database when parm IM/import is
Exists.

Personal use is good.

The Code is as follows (dbio. php)

1. <? PHP
2. /**
3. * @ File dbio. php
4. * Import/export/truncate tables from a database, one file per table
5. * Import/im tb: // User: passwd @ localhost/database path [-N]
6. * Export/ex TB: // User: passwd @ localhost/database path
7. * Truncate/tr tb: // User: passwd @ localhost/database path
8. *
9. * Mit license
10. *
11. * $ ID $
12. */
14. /* VIM: Set tabstop = 4 shiftwidth = 4 expandtab :*/
15. Define ('schema _ database', 'schema. SQL ');
17. Function usage ($ order ){
18. Echo "Usage: PhP $ order IM/import/EX/export/TR/truncate DB: // User: password @ host/database path [-N]/n ";
19. Echo "im/import/T is import DB from SQL files which is exists;/N ";
20. Echo "EX/export/T is export dB to SQL files;/N ";
21. Echo "TR/truncate/T is empties all tables in this database; the parm 'path' will be ignored .";
22. Echo "Path:/t the directory of the SQL files;/N ";
23. Echo "[-N] is optional parameter just for create new database when parm IM/import is exists./N ";
24. Die ();
25. }
27. Function checkparams ($ argv, $ argc ){
28. If ($ argc <3 | $ argc> 5 ){
29. Foreach ($ argv as $ ELEM ){
30. If (! Assert ($ ELEM) return false;
31. }
32. Return false;
33. }
34. Return true;
35. }
37. Function actionimport ($ TB, $ user, $ passwd, $ host, $ database, $ path, $ new ){
38. $ Dbconn = mysql_select_db ($ database );
39. If (! $ Dbconn ){
40. If ($ new = '-n '){
41. Echo "now create database $ database./N ";
42. Mysql_query ("create database $ Database ");
43. $ Exec = "mysql-h $ host-U $ user-p $ passwd $ database <$ path/". schema_database;
44. Passthru ($ Exec );
45. } Elseif ($ new = ''){
46. Echo "database do not exist !, You need Param '-n' at last./N ";
47. Die ();
48. }
49. }
50. $ Files = scandir ($ PATH );
51. If (! $ Files ){
52. Echo "Check Params $ path ";
53. } Else {
54. $ SQL _file = preg_grep ("/[a-zA-Z0-9] */. SQL $/I", $ files );
55. Echo "now start importing </N ";
56. Foreach ($ SQL _file as $ ELEM ){
57. If ($ ELEM = schema_database) continue;
58. $ Exec = "mysql-h $ host-U $ user-p $ passwd $ database <$ path/$ ELEM ";
59. Dopassthru ($ Exec );
60. }
61. }
62. }
64. Function actiontruncate ($ database ){
65. Echo "now emptying all tables exporting >>>>/N ";
66. $ Result = mysql_list_tables ($ database );
67. $ TBS = array ();
68. For ($ I = 0; $ I <mysql_num_rows ($ result); $ I ++)
69. $ TBS [] = mysql_tablename ($ result, $ I );
70. Mysql_free_result ($ result );
71. Foreach ($ TBS as $ ELEM ){
72. $ Exec = "truncate $ ELEM ";
73. $ Result = mysql_query ($ Exec) or die ($ exec. 'failed ');
74. }
75. Echo "truncate success .";
76. }
78. Function actionexport ($ TB, $ user, $ passwd, $ host, $ database, $ path, $ new ){
79. Echo "now start exporting ---/N ";
80. $ Result = mysql_list_tables ($ database );
81. $ TBS = array ();
82. For ($ I = 0; $ I <mysql_num_rows ($ result); $ I ++)
83. $ TBS [] = mysql_tablename ($ result, $ I );
84. Mysql_free_result ($ result );
85. Foreach ($ TBS as $ ELEM ){
86. $ Exec = "mysqldump-h $ host-U $ user-p $ passwd-Q-T $ database $ ELEM> $ path/$ ELEM. SQL ";
87. Dopassthru ($ Exec );
88. }
89. $ Exec = "mysqldump-h $ host-U $ user-p $ passwd-Q-d $ database> $ path/". schema_database;
90. Dopassthru ($ Exec );
91. }
93. Function dopassthru ($ Exec ){
95. Echo $ exec;
96. Passthru ($ exec, $ RET );
97. If ($ RET! = 0 ){
98. Echo ": Failed/N ";
99. } Else {
100. Echo ": OK/N ";
101. }
103. Return true;
104. }
106. // Main ()
107. If (checkparams ($ argv, $ argc )){
108. $ Action = $ argv [1];
109. List ($ TB, $ tmp1, $ tmp2, $ user, $ passwd, $ host, $ database) = Split ('[: // @]', $ argv [2]);
110. $ Path = $ argv [3];
111. $ New = $ argv [4];
113. If (! Mysql_connect ($ host, $ user, $ passwd) Die ("cocould not connect to MySQL ");
116. Switch ($ action ){
117. Case 'im ':
118. Case 'import ':
119. Actionimport ($ TB, $ user, $ passwd, $ host, $ database, $ path, $ new );
120. Break;
121. Case 'X ':
122. Case 'Port ':
123. Actionexport ($ TB, $ user, $ passwd, $ host, $ database, $ path, $ new );
124. Break;
125. Case 'tr ':
126. Case 'truncate ':
127. Actiontruncate ($ database );
128. Break;
129. Default:
130. Die ("Action Param '$ action' is error !!! ");
131. }
133. } Else {
134. Usage ($ argv [0]);
135. }
136. ?>