How to import a full backup ?

Hi,

I changed my host provider and i made a full backup of the databases there is possible to import all databases all together with new names and what is the way ?

 

if u have shell access then just import them with mysql command

 

You should make them separately

 

If you do not have shell access then you could use a tool like phpMyAdmin to import your MySQL databases (if your new web host provides such facilities). It may however be necessary to create the databases through your host's control panel before importing your data.

 

Full root directory backups can be imported by contacting your new hosting provider.

If you don't want to do that, you can manually extract the folders and files using any multi-archive reader.. (such as powerarchiver, etc)... Then upload them via FTP/cpanel etc.. And import the SQL files using phpMyAdmin (most hosts use this).

Chuckun

 

you must use shell access in order to sql LOAD your file unto your DB
since PHPmyAdmin allows 51KB file only (not sure about the real filesize)

 

Use bigdump. Upload the sql files on your root and then with the help of bigdump.php script you can upload the entire database. Largest I have imported was 150MB. http://www.ozerov.de/bigdump.php

 

bigdump all the way

 

try using phpmyadmin it will give you facility to import if you have file in sql format at your system. Its just like a wizard so dont worry you can do it yourself.

 

BigDump is the best option