Announcement

Collapse
No announcement yet.

importing file into db

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
    Colin F
    Senior Member

  • Colin F
    replied
    Seems that actually is a sql file.
    Go ahead and import it

    Leave a comment:

  • tRichard
    Member

  • tRichard
    replied
    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)
    );

    Leave a comment:

  • Colin F
    Senior Member

  • Colin F
    replied
    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?

    Leave a comment:

  • tRichard
    Member

  • tRichard
    replied
    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?

    Leave a comment:

  • Steve Machol
    Former Customer Support Manager

  • Steve Machol
    replied
    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/m...ce_ssh_restore

    Leave a comment:

  • tRichard
    Member

  • tRichard
    replied
    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?

    Leave a comment:

  • Colin F
    Senior Member

  • Colin F
    replied
    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.

    Leave a comment:

  • tRichard
    Member

  • tRichard
    started a topic importing file into db

    importing file into db

    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
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X