How does mysql export files? Please kindly advise !!! Mysql & gt; selectversion (); current_date; + ------------------ + | version () | + ------------------ + | 5.1.36-community | + ---------------- + 1 rowinset (0.00 mysql file export problem? Please kindly advise !!!
Mysql> select version (); current_date;
+ ------------------ +
| Version () |
+ ------------------ +
| 5.1.36-community |
+ ------------------ +
1 row in set (0.00 sec)
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
Corresponds to your MySQL server version for the right syntax to use near 'curre
Nt_date 'at line 1
Mysql> select version (); current_date;
+ ------------------ +
| Version () |
+ ------------------ +
| 5.1.36-community |
+ ------------------ +
1 row in set (0.00 sec)
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
Corresponds to your MySQL server version for the right syntax to use near 'curre
Nt_date 'at line 1
Mysql> show databases;
+ -------------------- +
| Database |
+ -------------------- +
| Information_schema |
| Metinfo |
| Mysql |
| Newnetinfo |
| Test |
+ -------------------- +
5 rows in set (0.00 sec)
Mysql> mysqldump-u root-p test> d: \ test. SQL;
Outfile disabled.
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
Corresponds to your MySQL server version for the right syntax to use near 'MySQL
Dump-u root-p test> d: est. SQL 'at line 1
Mysql>
I checked that mysql is 5.1.36. how can I export it successfully? is it a version problem? How can this problem be solved? Thank you !!!
------ Solution --------------------
Mysqldump is executed under the command line...
------ Solution --------------------
For example, win's dos
