Help me to Import mysql databases from web into home pc !

Philip

My friends site, he said that he already have a mysql databases about 10 mega.

And he tried to import to him pc after he had back up from him site..

But it seem it's failed, the Apache from php triad, came message like this.. Php countered error, process more than 30 seconds,

Is there any way can i used to import mysql databases without using phpmyadmin, and faster than phpmyadmin ??

Thanks99x,

Philip

mOrpheuS

The most obvious solution would be to manually split/upload the dump in smaller parts. (you must be careful to split it right places though)

What database is that ? phpBB ?
if yes, then you can remove the <prefix>_search_wordlist table data from the dump and your dump will be cut down by almost half.

A quick google of the problem also gave me this -

http://www.ozerov.de/bigdump.php

Philip

uhm, i think i will test it first,

Thanks sir morpheus Embarassed

Philip

Sir morpheus, thanks99x very much .

Your tips its working very well,
I & My friends Chop it to 10 files first, after that we import Smile

Thanks,
Philip

Helios

Hey Sir Morpheus..

When did you become a knight??

WickedGravity

If you are Sir Morpheus, am I a squire? a page?

Or do I lord over you as a duke or a count?

an equal?

a commoner?

mOrpheuS · Posted: Fri Jul 08, 2005 7:46 am

How to import mysql databases from text files?
MySql Databases
Export and Import Mysql Table
Can't create or alter name of MySQL databases
protecting mysql databases from sql injection attacks

mysql databases
PHP.ini and MYSQL databases
General error - mysql server has gone away.
Help on Backing up MySQL Databases
Fixing 'Can't Connect to database' errors with phpBB.

Need Help integrating php variable into mySQL SELECT query
Need help with mySQL
Tutorial: How to write HTML without ANY code whatsoever!
How To : Improve Your PHP Programming
Choosing Between Free or Paid Web Hosting