Restore from backup

[rsi]

If I backup my db into .sql file how can I restore from it?

[pestilence]

all the information

The information you require is in the manual under the moving servers section.

http://www.vbulletin.com/manual/movingservers.html

[rsi]

I want to move it to my own comp running Apache 1.3.19 and Mysql and php4, I can't telnet to 127.0.0.1, how can I import the db?

[tubedogg]

Just run mysql at the command prompt.

[rsi]

I get this when I do it:
"E:\Server\MySql\Bin>mysql -uAdmin -p***** forum < E:\Backup\vbulletin.sql
ERROR 1048 at line 598: Column 'metakey' cannot be null"

[Mike Sullivan]

AFAIK, none of our tables have a column called metakey.

Although you could most likely fix that error nonetheless by using MySQL 3.23.

[Savage]

Importing Backup Over Existing Data

The tutorial on restoring a backup that you have provided is good if you are wanting to create a new database and import the data. I am merely wanting to import the data from my backup file OVER the existing data in my database, as I have seemingly messed it up while playing with it. I am trying to do all of this with phpmyadmin, as I do not have telnet access. Thanks, David

[rsi]

Am already using it.

[rsi]

Any one have an idea? it's happened to me also using phpMyAdmin?