Results 1 to 7 of 7

Thread: How to restore my phpbb database files?

  1. #1
    intelli is offline Experienced Net Builder
    Join Date
    Jan 2009
    Posts
    140
    Blog Entries
    2
    Thanks
    43
    Thanked 11 Times in 9 Posts

    How to restore my phpbb database files?

    Hi there,

    I have done this kinda things earlier when I changed my server to a new one.
    Again, I'm in a similar situation. I tried to upload the backup file by entering phpmyadmin and then issuing the import command. But as always it returns some error. Ahh, I don't use import function for the same reason - earlier i used - some utility to restore - if i remember it correctly- it was a php file and i had to upload it to my server - I had to enter db details, destination sql file details etc in that php file - and things went fine that time - i was able to restore a big sql dump file. But I just don't remember that things name - also this time the file is just 3.5 mb in size ---- I have the file in my server - so i think there would be some way to store it to the right place from the server itself - i mean is there any need to download to my pc again ? anyways its in the server only - there is a need to just do some importing - actually its a .sql file - and some sql commands have to be run - thats all.


    Anyone pls come up with some ideas....

  2. #2
    Shenron's Avatar
    Shenron is offline Administrator
    Join Date
    Dec 2008
    Location
    Portugal
    Posts
    1,900
    Blog Entries
    2
    Thanks
    561
    Thanked 548 Times in 368 Posts
    This is what you're looking for:

    BigDump: The Staggered MySQL Dump Importer

    I wonder when the hell phpmyadmin will start handling imports properly...

  3. Thanked by:

    intelli (8 July, 2009)

  4. #3
    Charles's Avatar
    Charles is offline Senior Net Builder
    Join Date
    Dec 2008
    Location
    On the Bike
    Posts
    1,211
    Blog Entries
    5
    Thanks
    311
    Thanked 311 Times in 212 Posts
    Quote Originally Posted by Shenron View Post
    I wonder when the hell phpmyadmin will start handling imports properly...
    I've never had any problems with doing so... It's all in how/where you export your database.

  5. #4
    intelli is offline Experienced Net Builder
    Join Date
    Jan 2009
    Posts
    140
    Blog Entries
    2
    Thanks
    43
    Thanked 11 Times in 9 Posts
    Yup, that is what I was looking for.
    Thanks Shenron. You deserve a "thanks"

  6. #5
    Shenron's Avatar
    Shenron is offline Administrator
    Join Date
    Dec 2008
    Location
    Portugal
    Posts
    1,900
    Blog Entries
    2
    Thanks
    561
    Thanked 548 Times in 368 Posts
    Quote Originally Posted by Charles View Post
    I've never had any problems with doing so... It's all in how/where you export your database.
    Not quite Charles, I've had many problems in the past and I always try to properly export the database, also, even though phpmyadmin announces it can handle 50Mb files, I always find a hard time restoring files with more than 10Mb.

  7. #6
    Charles's Avatar
    Charles is offline Senior Net Builder
    Join Date
    Dec 2008
    Location
    On the Bike
    Posts
    1,211
    Blog Entries
    5
    Thanks
    311
    Thanked 311 Times in 212 Posts
    Quote Originally Posted by Shenron View Post
    Not quite Charles, I've had many problems in the past and I always try to properly export the database, also, even though phpmyadmin announces it can handle 50Mb files, I always find a hard time restoring files with more than 10Mb.
    I managed to import a 150MB article database about half a year ago. Fluke?

  8. #7
    TopDogger's Avatar
    TopDogger is offline Über Hund
    Join Date
    Jan 2009
    Location
    Hellfire, AZ
    Posts
    3,102
    Thanks
    349
    Thanked 918 Times in 702 Posts
    I have never had a problem moving large SQL files.

    3.5mb is not very large. I wonder if you are running into the compatibility issue with different versions of MySQL.

    Are you using an old version of MySQL on one of the servers? If remember correctly, some of the file parameters changed around version 4.1.

    I once had a problem restoring an old SQL file and I had to manually change some of the parameters in the SQL file to get past the errors. The errors were coming from some of the MySQL parameters tagged on to the end of the CREATE TABLE command.
    "Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote." -- Benjamin Franklin


Similar Threads

  1. Admin Community Doc #2 - How to restore your file backup
    By el canadiano in forum Community Building
    Replies: 3
    Last Post: 21 June, 2010, 02:32 AM
  2. [phpBB] - Happy 10th Birthday phpBB!
    By StephenM in forum Community Software
    Replies: 0
    Last Post: 18 June, 2010, 02:57 AM
  3. Possible create files like this ?
    By SonnyCooL in forum Blogging
    Replies: 4
    Last Post: 1 June, 2010, 15:38 PM
  4. [phpBB] - Announcing Titania, the Customisation Database
    By StephenM in forum Community Software
    Replies: 0
    Last Post: 27 April, 2010, 03:22 AM

Tags for this Thread

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
  •