The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'Database Discussions' started by rkgroups, Apr 2, 2007.

  1. rkgroups

    rkgroups Member

    Joined:
    Nov 12, 2006
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    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.
     
  2. david510

    david510 Well-Known Member

    Joined:
    Aug 22, 2004
    Messages:
    473
    Likes Received:
    0
    Trophy Points:
    16
    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.
     
  3. AlexandreVeezon

    AlexandreVeezon Well-Known Member

    Joined:
    Dec 9, 2005
    Messages:
    99
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    /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
     
  4. jayh38

    jayh38 Well-Known Member

    Joined:
    Mar 3, 2006
    Messages:
    1,215
    Likes Received:
    0
    Trophy Points:
    36


    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.
     
Loading...

Share This Page