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!

Upload mySQL Databases

Discussion in 'General Discussion' started by Huminie, Dec 30, 2003.

  1. Huminie

    Huminie Member

    Nov 24, 2003
    Likes Received:
    Trophy Points:
    I am looking for some suggestions on moving mySQL databases. I have 3 sites on a non-cPanel host and I am moving them to my new VPS with cPanel. Each site uses at mySQL database for phpBB forums.

    I can use phpmyadmin to download the databases from the 'old' site, but I can't get them to upload. According to the folks at the phpBB site, databases over 2MB (tops) can't be uploaded via phpmyadmin. My databases are well over this and uploads for me time out.

    Can you recommend a better way?

    I have root access to the server, but am not real savy with command line Linux. I am thinking there has to be a way to just upload the .sql file via ftp and the move it to the appropriate location on the server, but I don't know how to find the files, or where to move them to.

    TIA for any help!
  2. jphilipson

    jphilipson Well-Known Member

    Jan 8, 2003
    Likes Received:
    Trophy Points:
    If you don't have any sites o nthe new box, you can just copy over the contents of /var/lib/mysql .. that will copy all the mysql data and users
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. GOT

    GOT Get Proactive!

    Apr 8, 2003
    Likes Received:
    Trophy Points:
    Chesapeake, VA
    cPanel Access Level:
    DataCenter Provider
    You could use a different front-end. I use MySQL Front which should not have that 2 meg limitation.
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...

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.
    Dismiss Notice