How to use MySQL database backup downloaded from cpanel on local pc?

[rkgroups]

Hi,

I downloaded MYSQL database from CPANEL "backup" icon. And, now I want to run the same database on my LOCAL PC running WINDOWS and XAMPP. SO I tried to import this database in my local machine by using PHPMYADMIN tool. But it gives me error that NO DATABASE CREATED. Why is it so? this happens in every database I download from my server..

Actually, when I try to process my database on server itself, server gets jammed. So I want to process my database on my local machine so that server works fine. So I downloaded the database. Now how to use that database on my local machine?? FYI: The database is of PHPMYADS now, OPENADS.

[david510]

I would recommend to install Linus OS on your local PC and install mysql server on it. You can easily manage the database locally then.

[_xandih]

Why don't you export mysql database with the mysqldump command?

This issue occurs because in your SQL file, you don't have the "CREATE DATABASE" command.
Make sure you're exporting with Full Create.. And if you don't know how to do this with mysqldump, above is an example:

mysqldump your_database --single-transaction > /pathto/your_dabasedump_file.sql

Where --single-transaction make sure that you will dump all of InnoDB data too. ;D

[jayh38]

I would recommend to install Linus OS on your local PC and install mysql server on it. You can easily manage the database locally then.

xampp is a full mysql / apache / php suite which is excellent for local dev if you arent familiar with it. No need for linux locally and no benefit over windows / xampp for dev.


Check out navicat. Its an excellent tool for managing remote and local databases. Drag and drop/dump or anything you like. Of course there are many free management tools but navicat is the best of the best IMHO.