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

rkgroups

Member
Nov 12, 2006
6
0
151
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.:confused: But it gives me error that NO DATABASE CREATED. Why is it so? this happens in every database I download from my server.. :mad:

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

Well-Known Member
Aug 22, 2004
473
0
166
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.
 

AlexandreVeezon

Well-Known Member
Dec 9, 2005
103
2
168
/br/sc/rionegrinho
cPanel Access Level
Root Administrator
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:

Code:
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

Well-Known Member
Mar 3, 2006
1,213
0
166
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.