PHPMyAdmin Timeout!

any advice?

[dreamcatcher]

I`m in the process of moving over to a new hosting company. I`ve backed up and transerred most of my databases with no problems, but my forum database keeps timing out when I back it up. When I run the backup file it never works. I`m using PHPMyAdmin v2.5 to access my databases.

Is there any way around this? Are there any tools you can download to make a clean backup?

Thanks.

:)

[Birdman]

You can actually write a quick script to write your own backup. The sql file is in a very simple format:

At the top it has the query that creates the table and then there is a row on each line set up to be INSERTED.

EXAMPLE:

CREATE TABLE widgets (
id int(4) NOT NULL default '0',
name varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

INSERT INTO widgets VALUES (1, 'blue widget');
INSERT INTO widgets VALUES (2, 'red widget');
INSERT INTO widgets VALUES (3, 'green widget');
etc...

Hope it helps.

[dreamcatcher]

Thanks Birdman. Only problem is my forum has 30 tables, with lots of information (rows) so I just want to save all the information and then upload it to the new server.

There is an option to save a mysql back up file in my hosting`s control panel. I downloaded that and it appeared to hold all the information, but when I upload the backup I keep getting "NO MYSQL QUERY" displayed when I run it. What a headache.

:(

[jaski]

Not sure why it should timeout...may be it holds a lot of data?

If you have telnet access .. you can do it with mysqldump command.

mysqldump dbname -u username -p[password] > file

-p[password] is without space.

[jaski]

ah .. it seems the problem is with your new server ..

again if you have telnet access to new server you can try doing it from command line..

mysql dbname -u [username] -p[password] < sql_file_name

[dreamcatcher]

Thanks for the help jaski. I have since found out that PHP MYAdmin does have a tendency to time out with PHP files. I`ve got a mysql tool I`m trying out. The forum does hold quite a bit of data, there are some 5000 rows of info.

With regards to telnet, yes I do have access, but I`ve never used it, so I wouldn`t know how to get it to work, sorry!

[dreamcatcher]

Well I seemed to have got it working. I split the file up into smaller files and run them as seperate queries, this worked ok. When I ran the whole file in one go there was about a 3min pause, then I got an error message. Must be something to do with the server.

Anyway, thanks for the help.

:)