从Ubuntu14.04LTS命令终端导出和导入MariaDb数据库时出错

Question

我是Ubuntu的新手。我已经在Ubuntu14.04LTS上安装了Xampp。请告诉我，这个导出数据库命令有什么问题吗？

mysqldump - u root -p sachin_copy_db > /home/sachin/Downloads/cl14-sachin_db.sql;

以下是我遇到的错误：

sachin@ubuntu:~$ /opt/lampp/bin/mysql -u root -p
MariaDB [(none)]> mysqldump - u root -p sachin_copy_db >  /home/sachin/Downloads/cl14-sachin_db.sql;
ERROR 1064 (42000): You   
have an error in your SQL syntax; check the manual that corresponds    to your MariaDB server version for the right syntax to use near    'mysqldump - u root -p sachin_copy_db >    /home/sachin/Downloads/cl14-sachin_db.sql' at line 1

此外，我在导入数据库时出错，下面是错误：

MariaDB [(none)]> mysql -u root -p sachin_copy_db < /home/sachin/Downloads/cl14-sachin_db.sql;
ERROR 1064 (42000): You
have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'mysql -u root -p sachin_copy_db < /home/sachin/Downloads/cl14-sachin_db.sql' at line 1

Answer 1

这些导入和导出数据命令需要直接从命令终端使用，如

导入数据命令

sudo /opt/lampp/bin/mysql -u root -p sachin_db_copy < /home/sachin/Downloads/cl134_sachin_db.sql;

导出数据命令

sudo /opt/lampp/bin/mysqldump -u root -p sachin_db_copy > /home/sachin/Downloads/cl135_sachin_db.sql