How to import large MySQL database to X10?

[lachu]

Hi!

I need to import large MySQL database on the X10 server, while trying with the phpmyadmin i get the following error:

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

Is there a way to access MySQL command prompt via telnet, so I may use 'mysql' command?

Or maybe there is yet completely different way to do it?

I have the phpMyAdmin dump of the database, as well as the mysqldump of it.

Uncompressed database is 22MB as phpmyadmin and 30MB as mysql dump file.

 

[MicrotechXP]

Try to upload it via the 'backup' feature in cPanel.

 

[lachu]

The backup tool is performing restore operation and then stops without any message, without completing the task.

How can I connect directly to the database, so I may for example use MySQL Migration Toolkit?

 

[bugfinder]

We dont tend to let people do direct connections from outside x10.

 

[lachu]

We dont tend to let people do direct connections from outside x10.

But what should I do then?
Is there any 3rd party script than can help me?
Any suggestions?

 

[Fedlerner]

You can import it using PhpMyAdmin. You will find it in cPanel.

 

[lachu]

You can import it using PhpMyAdmin. You will find it in cPanel.

Didn't I tell in the first post that I have already tried with phpmyadmin? :happysad:

 

[bugfinder]

Have you ftp'd up the file and tried running it from a script?

 

[Synkc]

Have you tried dividing the MySQL dump file into several chunks, and importing each one separately via phpMyAdmin?

 

[lachu]

Have you ftp'd up the file and tried running it from a script?

I tried using some scripts today (bigdump, mysqldumper1.22), but I couldnt run them, at first it was like nothing was there, there was no response from the server and now I get this error, when trying to run them:

500 Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@lachu.exofire.net and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

What am I doing wrong?

Have you tried dividing the MySQL dump file into several chunks, and importing each one separately via phpMyAdmin?

I think I'll try this as a last resort option.

 

[Corey]

Upload the SQL file to your account, create an empty database for it, post the database name here after you have uploaded it.

I will import it via SSH.

-Corey

 

[lachu]

Upload the SQL file to your account, create an empty database for it, post the database name here after you have uploaded it.

I will import it via SSH.

-Corey

Thanks a million! :biggrin:

But what bothers me the most is the fact that I cant run any php scripts on my account, I tried to upload this file with 'bigdump' and 'mysqldumpster' which are both php based and I couldnt run them at all. I think I could upload this database with 'bigdump' tool but when I tried to use it I was getting a blank page or the internal server error page. The scripts were located in 'public_html' subfolder.

Do I have to activate php somehow first?

***

I have uploaded the file to my account, main folder, file name is 'gusm.sql'.

My database that I created is called 'lachu_gus'.

 

[Corey]

I imported it, please verify it went correctly.

Yes, you should upgrade your PHP version to intermediate. You can do this through the account panel at http://x10hosting.com/account

-Corey