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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Moving SQL Databases...

Discussion in 'Database Discussions' 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

    :)
     
    #2 Zachery, May 1, 2005
(You must log in or sign up to post here.)
Loading...
Similar Threads - Moving Databases
  1. RobinMiller

    SOLVED Removing starred user from User Manager

    RobinMiller, Oct 10, 2017, in forum: General Discussion
    Replies:
    7
    Views:
    102
    cPWilliamL
    Oct 18, 2017 at 10:25 AM
  2. Bidi

    Moving MySQL directory

    Bidi, Aug 19, 2017, in forum: Database Discussions
    Replies:
    1
    Views:
    123
    cPanelMichael
    Aug 22, 2017
  3. Matthew Wakeford

    Moving Hosting to cPanel DNS Question

    Matthew Wakeford, Aug 7, 2017, in forum: Bind / DNS / Nameserver Issues
    Replies:
    3
    Views:
    192
    cPanelMichael
    Aug 8, 2017
  4. Mauritz

    Removing home2 partition

    Mauritz, Jul 11, 2017, in forum: Data Protection
    Replies:
    1
    Views:
    255
    cPanelMichael
    Jul 11, 2017
  5. WorkinOnIt

    Moving server - DNS and TTL

    WorkinOnIt, Jun 15, 2017, in forum: Bind / DNS / Nameserver Issues
    Replies:
    3
    Views:
    248
    kssuhesh
    Jun 22, 2017

Share This Page