princessmandy
02-03-2006, 09:09 AM
I'm using putty to ssh the backup from the old database on a different server, fresh install of vb, and am trying to restore the database into the new one using the command line
Code:
mysql -h servername -u dbusername -p databasename < /path/to/backupname.sql
Keep getting a directory and file not found error. Could it be the path I have wrong? the backup.sql is in the domain's root directory and using the path of /home/domain/backup.sql
I tried all sorts of paths and can't get it working. Would anyone know the correct path for this command?
Thank you for any help! We been working to fix it for 6 hours LOL. :disappointed:
Code:
mysql -h servername -u dbusername -p databasename < /path/to/backupname.sql
Keep getting a directory and file not found error. Could it be the path I have wrong? the backup.sql is in the domain's root directory and using the path of /home/domain/backup.sql
I tried all sorts of paths and can't get it working. Would anyone know the correct path for this command?
Thank you for any help! We been working to fix it for 6 hours LOL. :disappointed: