Announcement

Collapse
No announcement yet.

importing file into db

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    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.
    Best Regards
    Colin Frei

    Please don't contact me per PM.

    Comment


    • #3
      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?

      Comment


      • #4
        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
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          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?

          Comment


          • #6
            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?
            Best Regards
            Colin Frei

            Please don't contact me per PM.

            Comment


            • #7
              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)
              );

              Comment


              • #8
                Seems that actually is a sql file.
                Go ahead and import it
                Best Regards
                Colin Frei

                Please don't contact me per PM.

                Comment

                widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                Working...
                X