importing an SQL file into a new db

[sjlsam]

i made a new db and im trying to import a gzipped sql file
although it's taking forever to finish

my gzipped sql file is 7mb

30 minutes is about as far as ive let it go, before trying it all over again
should i just let it go for a few hours or do you think i'm doing something wrong?

[sjlsam]

it says its passed 300 seconds
how else am i supposed to get my dbase up?

Fatal error: Maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/read_dump.lib.php on line 91

[sjlsam]

i managed to fix the problem by using wordpad and cutting/pasting the database into parts, small parts
it let me upload those individually

[Grant29]

The easiest way is to do:

1. Create your DB via the cpanel gui

2. FTP your sql file to your site (non-gzipped).

3. SSH into your site via putty.

4. Get to the directory with the db file and use: mysql yourdbname<db.sql

(Adjust filename as needed). For 7mb it shouldn't take more than a few seconds.

[sjlsam]

The easiest way is to do:

1. Create your DB via the cpanel gui

2. FTP your sql file to your site (non-gzipped).

3. SSH into your site via putty.

4. Get to the directory with the db file and use: mysql yourdbname<db.sql

(Adjust filename as needed). For 7mb it shouldn't take more than a few seconds.

yeah this does work, but you have to have a confirmed SSH account before u can use it (requires activation from hostrocket)

there is an easier way of just splitting the database up into parts!

thanks for your reply, that will def work also

[Grant29]

Yes, splitting it works too, I've done that before. I have some 100MB+ databases. If you get to that point splitting the sql file becomes a pain...