Results 1 to 5 of 5
  1. #1

    Question Transfer MySQL Without A Control Panel

    I am currently trying to transfer a website from a server with WHM/Cpanel to a server that doesn't have any control panel at all. I have transferred the files with SSH, but I am not sure how I can transfer the MySQL databases. I found the MySQL files on the old server and used wget to send them to the new server, but how can I connect to them?

    I put the files in /home/mysql/site_user with root access, not sure if this is correct though.

  2. #2
    Use mysqldump at the source server and then load that dump on the target server using somthing like

    mysql -u username -p password < dumpdile.sql

  3. #3
    Will that create the username and password for me?

  4. #4
    No actually those are the mysql root credentials that you should put there because you have root access.

    Take a look at the following
    http://www.devshed.com/c/a/MySQL/Bac...ySQL-Database/

  5. #5
    Join Date
    Jan 2005
    Location
    Scotland, UK
    Posts
    2,549
    mysqldump is the best way, however use /var/lib/mysql or just create the cpanel backup and then untar it, and move the mysql data files to /var/lib/mysql, but since its too one of our servers I will do it for you
    Server Management - AdminGeekZ.com
    Infrastructure Management, Web Application Performance, mySQL DBA. System Automation.
    WordPress/Magento Performance, Apache to Nginx Conversion, Varnish Implimentation, DDoS Protection, Custom Nginx Modules
    Check our wordpress varnish plugin. Contact us for quote: [email protected]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •