September 4th, 2012, 01:47 AM
Duplicate database and its data from command line
How can I do this properly?
mysqldump -u behnam -p behnampassword h2g_database | mysql -u behnam backup -p behnampassword h2g_database_2;
But as you see, this fails
September 4th, 2012, 01:10 PM
I don't normally use the command line but i believe you are not supposed to have a space between -p and password
Originally Posted by zxcvbnm
otherwise do you get a error? if so what is it?
mysqldump -u behnam -pbehnampassword h2g_database | mysql -u behnam backup -pbehnampassword h2g_database_2;