What to do.. can't use phpMyAdmin

Customer Support Customer Only Discussion
1

Hi Folks,

Please be gentle as databases are not my strong point! o_O

I have a client where I am attempting to move and restore a database they sent to me. (It is fairly large at about 80 mb. I first created a new blank MYSQL database thinking I could import the .sql file to restore it…but it is too large for that.

I then found a script I thought I could possibly use called “BigDump” but that won’t run either as it can’t find the database server. (I believe I am using all the right credentials in the script but it doesn’t seem to work.)

Does anyone have any advice for something to use besides phpMyAdmin that will connect to the mysql database and allow me to import the .sql file?

Is this something I need help from support with?

Thanks!

2

You can either upload the database using any MySQL compliant tool (like MySQL Administrator, Aqua data studio, SQLyog, HeidiSQL etc.) Or upload the backup file(.sql file) in your FTP space, open a support ticket with database details, and we will do the restore for you.

It is not possible to restore large database with phpMyAdmin.

3

Thanks Abhishek..I will give it a go trying the tools you mentioned…and If I get stuck I will go the ftp with support route.

Thanks again!