Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Moving SQL Databases...

Discussion in 'Database Discussion' started by KonokoHost, May 1, 2005.

  1. KonokoHost

    KonokoHost Member

    Joined:
    Mar 25, 2003
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    151
    Location:
    Chino Hills, CA
    A client had given us a VBulletin SQL database dump was made so we could transfer an SQL database to our server from the old server. Its named forums.sql
    The old server was a Direct Admin server running MySQL 4.1

    We have a CPanel server running MySQL 4.0.

    What would be the proper most efficient way of putting this database into his account without using PHPMyAdmin? (It's a 30mb file)

    -randyc
     
    #1 KonokoHost, May 1, 2005
  2. Zachery

    Zachery Member

    Joined:
    Apr 15, 2004
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    151
    Restoring it via the command line. You should never rely on web based scripts to backup or restore databases.

    Since the new server was running 4.1 you will need to go and cleanup the database first.

    At the end of each table create there should be a default character set bit, you need to remove that. Then you will be able to restore it via the shell


    mysql -uUSERNAME -pPASSWORD databasename < /path/to/file.sql

    :)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 Zachery, May 1, 2005
(You must log in or sign up to post here.)
Loading...
Similar Threads - Moving Databases
  1. bdp31770

    Removing and Re-adding Domain and MX Records

    bdp31770, Oct 12, 2018 at 8:16 AM, in forum: E-mail Discussion
    Replies:
    1
    Views:
    47
    cPanelLauren
    Oct 16, 2018 at 9:21 AM
  2. osamaweb

    Removing autossl rules on htaccess

    osamaweb, Sep 30, 2018, in forum: Security
    Replies:
    3
    Views:
    106
    cPanelLauren
    Oct 5, 2018
  3. dstana

    Moving Domain for an Account Issue

    dstana, Sep 27, 2018, in forum: Bind/DNS/Nameserver
    Replies:
    6
    Views:
    115
    cPanelLauren
    Oct 11, 2018 at 2:48 PM
  4. blue-earth

    Removing Email Archives Question

    blue-earth, Sep 21, 2018, in forum: E-mail Discussion
    Replies:
    2
    Views:
    109
    cPanelLauren
    Sep 21, 2018
  5. webiliza

    Error removing subdomain

    webiliza, Sep 19, 2018, in forum: cPanel Developers
    Replies:
    1
    Views:
    97
    cPanelMichael
    Sep 21, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice