Issue
apologies for how simple this question will be to followers of the SQl and SSH tags.
I would like to upload a copied database into a new database.
I created a copy of a data base I'd like to duplicate into my root folder. My root folder now contains a file "sitename_duplicate" with all the data.
In my web host control panel I created a new database "20130924_sitename"
I cannot seem to upload the contents of sitename_duplicate into 20130923_sitename.
mysql -u myname -p sitename_duplicate < 20130923_sitename.sql
-bash: 20130923_sitename.sql: No such file or directory
mysql -u myname -p 20130923_sitename < sitename_duplicate.sql
-bash: sitename_duplicate.sql: No such file or directory
The database with the data is sitename_duplicate and it's in the root. The blank and newly created database is 20130923_sitename.
How do I move the contents of sitename_duplicate into 20130923_sitename using SSH?
Solution
The syntax is
mysql -u username -pPassword --host hostname database_name < dump.sql
So it should be for you:
mysql -u myname -pMyPassword 20130924_sitename < sitename_duplicate
Answered By - herrjeh42 Answer Checked By - Mildred Charles (WPSolving Admin)