Import database

[ASTRAPI]

Hello

It will work if i try to restore a database using GUI cpanel or i will need ssh?

The database is 120mb.

Thank you

[chinmay]

Hello

It will work if i try to restore a database using GUI cpanel or i will need ssh?

The database is 120mb.

Thank you

Yes, you can restore/import the database through phpmyadmin. It would get restored.

If you are familiar with the SSH and the linux commands, you can even give it a try with restoring the database via SSH. The command to restore the database is

root@server [~]# mysql database_name < database.sql

mention the absolute path of database.sql file.

[cPanelEric]

It might work in phpmyadmin, but it will work for sure with SSH. I would strongly recommend using SSH.

You can use something like this example below. Change out the parts in <>'s with your information.

eric@svr01 ~ $ mysql -u <username_dbuser> -p <username_dbname> < sqlfilename.sql

It should prompt you for the password and return another ssh line when it's done. (And with 120megs it might take a little while)

[linux7802]

Yes its better if you upload the database backup file on your server in .sql format and restore it from shell.

Gunjan@servers~]$mysql username_databasename < sqlfilename.sql

If you are not having Server access then follow the steps.

1) Upload the sql file in .sql format under your hosing account.

2) Provide database name and .sql file name to your hosting provider and ask
them to restore it under your database name.

Hope it will solve your issue...

[ASTRAPI]

Ok ssh seems to be the best solution

Thanks all of you