importing file into db

[tRichard]

ok so i finally got the impex system working but man this confusing!

I have a backup db with filename upgrade1.php. It is approx 8mb. How can I input this db into the new db?
pls hlp
peace, Rich

[Colin F]

A database shouldn't have a filename.

You should import the data from your old database (which is most likely stored in an *.sql file) to a new database. Then, insert the details for this database in the Impexconfig.php file and run through the modules.

[tRichard]

this is what is confusing...my backup db that sits on my harddrive was saved as upgrade1.php when i installed a newer version of vb on my server in a different dir. This upgrade1.php file contains sql code and contains all the tables that all scripts use on my website, my entire db.
Is there no way i can import this code into the new mysql db without making it a db?
Would I need my network administrators help with this one?

[Steve Machol]

In order to be able to import it, you need to restore that backup to a new database.

The only reliable method of restoring a database is with shell access via telnet or ssh. Please see the instructions here:

http://www.vbulletin.com/docs/html/maintenance_ssh_restore

[tRichard]

so i need to restore the upgrade1.php file to a database using, say, PuTTy with the following command:

mysql -u dbusername -p databasename < /path/to/backupname.sql

is the "/path/to/backupname.sql" the path to the file upgrade1.php.. or is it the new database that will be created by restoring upgrade1.php?

[Colin F]

Yes, that's the path to upgrade1.php... allthough I still feel that it should be an *.sql file.

Could you post the first few lines of your upgrade1.php file here please?

[tRichard]

DROP TABLE IF EXISTS access;
CREATE TABLE access (
userid int(10) unsigned NOT NULL,
forumid smallint(5) unsigned NOT NULL,
accessmask smallint(5) unsigned NOT NULL,
PRIMARY KEY (userid,forumid)
);


DROP TABLE IF EXISTS adminhelp;
CREATE TABLE adminhelp (
adminhelpid int(10) unsigned NOT NULL auto_increment,
script varchar(50) NOT NULL,
action varchar(25) NOT NULL,
optionname varchar(25) NOT NULL,
displayorder smallint(5) unsigned DEFAULT '1' NOT NULL,
volatile smallint(5) unsigned NOT NULL,
PRIMARY KEY (adminhelpid),
KEY phraseunique (script,action,optionname)
);

[Colin F]

Seems that actually is a sql file.
Go ahead and import it