Page 1 of 1

Problems importing database!

Posted: Thu Jun 16, 2005 2:35 pm
by Jorg
Hi all,

this is frustrating the heck out of me. I am trying to import the database from my old to new provider. Somehow the MySQL phpMyAdmin 2.6.0 console will not import the tables. I am getting timeout errors:

Fatal error: Maximum execution time of 60 seconds exceeded in /var/www/html/phpMyAdmin-2.6.0-pl3/libraries/read_dump.lib.php on line 173

Trying a few tables at the time works, but it chokes on the largest of them all, the posts table.

This is very serious as I cannot get the darn database in the new site. Does anybody have any ideas or experience with backing up and restoring databases?

Is there a mysql query I can do on the command line perhaps to get the database in?


- Jorgen

Posted: Thu Jun 16, 2005 5:40 pm
by Avi
Hey, I've encountered the same problems (timeouts... max size... etc..) on my sites... I remember that using mysql_tool helped me!

EDIT: almost forgot! To change the timeout in mysql tool:
If you are still getting time out problems try forcing a lower execution time between refreshes by editing "var $maximum_time = 0;" on line 26 changing 0 to the number of seconds you wish the script to execute (work up from 15)

Posted: Thu Jun 16, 2005 6:27 pm
by Jorg
Hi Avi,

Thanks a lot for your help! However, my &%&%$^ current hosting service reports this;

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 1167 bytes) in /home/virtual/site155/fst/var/www/html/###/mysql_tool.php on line 641

I only selected the wxwidgets board tables. Ohh well. I will wait for SSH access tomorrow and try it with the command line prompt.

- Jorgen

Posted: Thu Jun 16, 2005 8:02 pm
by Avi
Well, I guess your server has a strict php/mysql access? Can you connect the mysql server externally? Try using MySQL Administrator...

Posted: Thu Jun 16, 2005 8:09 pm
by Jorg
Nope unfortunately not. But what I will do is simply import it with the mysql command line (prays the hosting has that) ... they already helped me great unfortunately I am not helped completely yet.

We will see, I will manage the hard way or the easy way ;-)

- Jorgen

Posted: Thu Jun 16, 2005 8:11 pm
by alexcoppo
Try splitting the original table into pieces (invent some where clause which cuts the whole table into smaller, mutually exclusive parts) and import the various pieces.

Posted: Thu Jun 16, 2005 8:31 pm
by Jorg
Uhm ... the text file is 55 Mb, this is about 400.000 lines of text. I am not even considering splitting this file up by hand :-(

I considered breaking up the tables or simply exporting a few sql tables but the wxwidgetsbb_posts is the biggest one and that table alone cannot be imported by uploading, the problem is that my upload takes longer then 60 seconds, and I cannot change that because it is set by the hosting.

I will figure it out though ;-) thanks fr your help!
- Jorgen

Posted: Thu Jun 16, 2005 9:56 pm
by krysa
If nothing works - try to use some simple php script to import the data. You can write a php script, that takes .sql file as input, splits the file into single queries, and executes those queries on the mysql server. this way, you can upload any .sql file of any size (ftp or something) and then use that script to import the data into database.

Posted: Fri Jun 17, 2005 8:31 am
by Jorg
Hi guys! I managed to do it! SSH is your friend!
My hosting service turned SSH on, and I performed the following steps;

mysql -D solidsteel_nl_-_ourdata -u solidsteel -p

> fill in password
mysql> connect
Connection id: 32852
Current database: solidsteel_nl_-_ourdata

> source localhost.sql

And all the queries are executed beautifully!

Now I will wait until the domain is transferred, and set up forum in the new site in the mean time.

- Jorgen