SitePoint Sponsor

User Tag List

Results 1 to 9 of 9
  1. #1
    SitePoint Addict
    Join Date
    Sep 2001
    Location
    London, UK
    Posts
    220
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Anyone know phpMyAdmin?

    Im trying to upgrade my forums from phpBB 1.4.4 to the latest version, 2.0.1. My upgrade to version 2.0.0 did not go smoothly, ( Ihave to upgrade via 2.0.0 to get it 2.0.1) the dates and times were corrupted, I need to go back to phpBB 1.4.4 and start the upgrade process again.

    I backed up my database before the upgrade.

    So Ive deleted all new & old installations of phpBB, reinstalled phpBB 1.4.4 and then tried to restore my database via phpMYAdmin with no luck. I select the sql file to upload and it says, SQL command executed sucessfully, but I don't see any of my old tables uploaded, just the defaults one created with the installation of phpBB 1.4.4. So then i dropped all those (so I had no tables showing) and restored my database in the same wawy, again I got the message, SQL command executed sucessfully, but no tables showing at all still. Ive done the above in IE browser as well as Mozilla.

    Anyone see where Im going wrong and what to do to correct it?
    stablewars.com - WWF Fantasy Wrestling, It ain't no E-fed!

  2. #2
    The short answer is yes... Herbster's Avatar
    Join Date
    Oct 2001
    Location
    Bay City, Oregon
    Posts
    715
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Is your sql file a dump?
    Can you post a bit of the code? Like for one table?

  3. #3
    SitePoint Addict
    Join Date
    Sep 2001
    Location
    London, UK
    Posts
    220
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Sure can, Its a very big file, but heres a very small snippet;

    # phpMyAdmin MySQL-Dump
    # version 2.2.0
    # http://phpwizard.net/phpMyAdmin/
    # http://phpmyadmin.sourceforge.net/ (download page)
    #
    # Host: localhost
    # Generation Time: July 26, 2002, 4:59 pm
    # Server version: 3.23.36
    # PHP Version: 3.0.15
    # Database : `DiscussionForum`
    # --------------------------------------------------------

    #
    # Table structure for table `access`
    #

    CREATE TABLE access (
    access_id int(10) NOT NULL auto_increment,
    access_title varchar(20) default NULL,
    PRIMARY KEY (access_id)
    ) TYPE=MyISAM;

    #
    # Dumping data for table `access`
    #

    INSERT INTO access VALUES ( '-1', 'Deleted');
    INSERT INTO access VALUES ( '1', 'User');
    INSERT INTO access VALUES ( '2', 'Moderator');
    INSERT INTO access VALUES ( '3', 'Super Moderator');
    INSERT INTO access VALUES ( '4', 'Administrator');
    # --------------------------------------------------------

    #
    # Table structure for table `banlist`
    #

    CREATE TABLE banlist (
    ban_id int(10) NOT NULL auto_increment,
    ban_userid int(10) default NULL,
    ban_ip varchar(16) default NULL,
    ban_start int(32) default NULL,
    ban_end int(50) default NULL,
    ban_time_type int(10) default NULL,
    PRIMARY KEY (ban_id)
    ) TYPE=MyISAM;

    #
    # Dumping data for table `banlist`
    #

    # --------------------------------------------------------

    #
    # Table structure for table `catagories`
    #

    CREATE TABLE catagories (
    cat_id int(10) NOT NULL auto_increment,
    cat_title varchar(100) default NULL,
    cat_order varchar(10) default NULL,
    PRIMARY KEY (cat_id)
    ) TYPE=MyISAM;

    #
    # Dumping data for table `catagories`
    #

    INSERT INTO catagories VALUES ( '1', 'General Discussion', '1');
    INSERT INTO catagories VALUES ( '2', 'Sports Entertainment', '2');
    INSERT INTO catagories VALUES ( '3', 'Games', '3');
    INSERT INTO catagories VALUES ( '4', 'PRIVATE - Staff', '4');
    # --------------------------------------------------------
    stablewars.com - WWF Fantasy Wrestling, It ain't no E-fed!

  4. #4
    SitePoint Addict
    Join Date
    Sep 2001
    Location
    London, UK
    Posts
    220
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    File im trying to upload is called, DiscussionForum.sql.php3 thats what it was saved as, if it means anything.
    stablewars.com - WWF Fantasy Wrestling, It ain't no E-fed!

  5. #5
    SitePoint Addict
    Join Date
    Sep 2001
    Location
    London, UK
    Posts
    220
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Im told phpMyAdmin version 2 is littered with bugs and may be the reason why I can't upload so im trying to install version 2.2.6 (is the latest complete version?). The current version is provided by my hosting company so Im not too sure how to do the installation

    Ive unzipped the files and placed them on my space, editing the config file, added user name, password and database name to it under the Server COnfiguartion section.

    Not clear on what Im supposed to do under this;

    /**
    * Your phpMyAdmin url
    *
    * Complete the variable below with the full url ie
    * http://www.mysite.com/url_location/
    *
    * It must contain characters that are valid for a URL, and the path is
    * case sensitive on some Web servers, for example Unix-based servers.
    */
    $cfgPmaAbsoluteUri = '';


    Ive changed the Url location to where it is on my host, although not sure how this effects it all as the above is all in comments, should I remove the comment tags?

    And secondly what am I supposed to do for; $cfgPmaAbsoluteUri, the configuration section is French to me!

    Has anyone installed phpMyAdmin on their webspace that can help me out?
    stablewars.com - WWF Fantasy Wrestling, It ain't no E-fed!

  6. #6
    SitePoint Addict
    Join Date
    Sep 2001
    Location
    London, UK
    Posts
    220
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    OK, Ive got this far and its all set up.

    Ive tried to upload a file, I select the file to upload and click go, after a period of time I get a message "No SQL query!"

    Nothing in the documentation which covers this message for trying to upload a file.

    Any ideas?
    stablewars.com - WWF Fantasy Wrestling, It ain't no E-fed!

  7. #7
    SitePoint Evangelist
    Join Date
    Jan 2002
    Location
    Scotland, UK
    Posts
    530
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Why is the file called .php3, try renaming it to .sql only.

  8. #8
    SitePoint Member
    Join Date
    Jul 2002
    Location
    Portland, OR
    Posts
    6
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Why use phpMyAdmin at all? Why not just RESTORE it from the phpBB admin control panel? It is just a mysql dump file. I agree it should be renamed to a *.sql extension, not *.php.

    Either that or just use MySQL to re-built it:

    • mysql database < backup-file.sql


    replacing 'database' & 'backup-file.sql' with the appropriate names. Am I missing something?

  9. #9
    SitePoint Addict
    Join Date
    Sep 2001
    Location
    London, UK
    Posts
    220
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I managed to get it sorted, file name wasn't a problem. Fact was I could only upload a certain size of file via my browser. So, solution was to break up the file into smaller peices and upload.

    Though that took a very long time, I did find another solution using software called mysqlman which i installed on my server and then ftp'ed my file up and ran the sql query direct from there, took an instant.

    Breaking up the file to upload took me over 6 hours as my file was very large.
    stablewars.com - WWF Fantasy Wrestling, It ain't no E-fed!


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •