Report this

What is the reason for this report?

How I duplicate a database in my linux?

Posted on February 12, 2016
Nay

By Nay

I have ubuntu 14 (nginx) and I’m ran that command to duplicate/export my database:

mysqldump -u[user] -h[localhost] -p[pwd] database1 > /home/database1.sql

And after I ran to import:

mysql -u[user] -h[localhost] -p[pwd] database2 < /home/database1.sql

And I get that message:

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 neurocriativi > /home/neurocriativi.sql’ at line 1

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Start building today

From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.