Uploading Database Backups via Shell

[RobAC]

I'm in the process of moving my site to a new server. Instead of using cPanel to add my databases via backups, what is the proper syntax needed to upload the database backups via Shell access?

[Wayne Luke]

http://www.vbulletin.com/docs/html/maintenance_ssh_restore (http://www.vbulletin.com/forum/../docs/html/maintenance_ssh_restore)

[RobAC]

Thanks Wayne,

Just a quick question. Should the database already be set up on the new server prior to restoring the backup?

The reason I ask is that if you restore a backup through cPanel, if the DB doesn't already exist, it creates it automatically - from the backup I assume.

[Wayne Luke]

Yes, you should create a database and assign appropriate permissions before importing the SQL file.

[Razasharp]

For a step by step: http://www.vbulletin.com/forum/showthread.php?p=1469351