Importing from another DB

[mrandall131]

My forum SW is moving to the next version and I have a test forum set up to evaluate it and decide whether I want to upgrade. I dowloaded my DB from the current forum and want to import that into another DB for the test forum to use. This way, I have data to check the new SW out with. When I go to import the DB file, I get tons of errors and nothing gets imported. Is there something special I need to do in order to get that data into the DB?

[mitchind]

Are both databases on Powweb?
And both are MySQL?
How did you try to do your import? PhpMyAdmin?

More details, error messages .. more help comes your way ...

[mrandall131]

Both databases are on PowWeb.
Both are MySql.

I downloaded the last backup of my forum's database. I then went into the new database and used the import command from the "sql" menu. If you need more, I'll get a couple of screen shots, but basically, no tables or data got added. Oh yeah, I did use PHPMyAdmin.

[mitchind]

You can try my online restore utility if you want. Others have had success with it.
http://www.purespeculation.com/download/upload_and_restore.zip

How large is the file? My online version has some limits to control abuse but works with large files.

I'll PM you the URL or you can try and download and setup the script yourself if you know a bit of CGI/PHP.

Updated: Sept 28, 2005 [Version 1.64]
Changes .........
- Fix relative path to images directory
- Check estimated time against maximum allowable when upload starts
- Check MySQL login data

[mrandall131]

I don't think I ever thanked you for your help, so THANKS!

[mitchind]

Glad it worked for you. :)

[Arun]

If mitchind's tool didn't work for you try doing this.
Connect to your DB using phpMyAdmin select the structure tab and check all tables at the bottom right of all tables, from the drop down menu select Check table if you find some errors in the result go back to structure tab again select all tables and select Repair table from the drop down menu this should repair all your tables and remove those errors when you import them.

Regards