Moving SQL Databases...

[KonokoHost]

A client had given us a VBulletin SQL database dump was made so we could transfer an SQL database to our server from the old server. Its named forums.sql
The old server was a Direct Admin server running MySQL 4.1

We have a CPanel server running MySQL 4.0.

What would be the proper most efficient way of putting this database into his account without using PHPMyAdmin? (It's a 30mb file)

-randyc

 

[Zachery]

Restoring it via the command line. You should never rely on web based scripts to backup or restore databases.

Since the new server was running 4.1 you will need to go and cleanup the database first.

At the end of each table create there should be a default character set bit, you need to remove that. Then you will be able to restore it via the shell


mysql -uUSERNAME -pPASSWORD databasename < /path/to/file.sql