[DeathByAnts]

I currently am trying to import a 30mb database into MySQL using PHPMyAdmin. The problem is, it continually times out and screws up the tables. Can anyone reccomend any alternatives that can be used through cpanel?

[blaw]

Hi there,

Through CPanel... why don't you chop up the data (i.e. your SQL file) into smaller chunks?

[DeathByAnts]

Originally Posted by blaw

Hi there,

Through CPanel... why don't you chop up the data (i.e. your SQL file) into smaller chunks?

because it is a LOT of code to break up each thing individually and I am going to have to do this a lot on the future.

[blaw]

I see...

If the problem is purely timeout, you can try manipulating the limit:

In phpMyAdmin's config.inc.php, there is a config var called $cfg['ExecTimeLimit']. You can set this to 0 (zero), which means infinite (up to the PHP's max excution time).

Open your php.ini and find max_excution_time and change the value to whatever the value (in seconds) you think would be sufficient for phpMyAdmin to finish excution. You may also want to check mysql.connect_timeout.

If you do not have access to your php.ini, I think these directives can be set via ini_set() on runtime, too:

PHP: ini_set - Manual
http://ca3.php.net/ini_set

I hope this time it's useful.

[ermau]

Or you could write a script to run through your sql file in intervals, like do the first 100 rows or so and then have the user hit next, do another 100 rows, etc.

[YourPHPPro]

If it is a SQL file, why not use the command line mysql client to connect to the mysql server and import the commands ? Something like:

mysql -h hostname -u username -ppassword database < sqlfile

[Dale]

Id use MySQL Front

Click here