Results 1 to 6 of 6
  1. #1

    Uploading SQL Databases by FTP

    To make a long story short, we have been trying to import sql databases through cpanel. The old server the client was on did not have any control panel. While the new server the client is migrating to, has cpanel. We try importing sql databases through cpanel, but because the sql databases are so large in size, they corrupt while importing them. The client's old server he would be able to access all his sql databases through FTP. While with this new cpanel server, we can't upload sql databases by FTP. We are wanting to use FTP because when using cpanel, the sql databases corrupt.

    So is there anyway to upload sql databases with FTP directly into mysql when using cpanel server?

  2. #2
    Hello, Please we need help ASAP on this issue. Thank you.
    Last edited by Benjamin; 02-25-2008 at 04:17 PM.

  3. #3
    Join Date
    Mar 2003
    Location
    Canada
    Posts
    9,072
    Quote Originally Posted by Benjamin View Post
    So is there anyway to upload sql databases with FTP directly into mysql when using cpanel server?
    Not directly, but if you upload the SQL databases to the server you can then use SSH (preferred) or create a PHP script to import the databases. Regardless of the method, the database has to exist in cPanel along with the user_name before you can import them.

    Does your host offer SSH access?
    RACK911 Labs | Penetration Testing | https://www.RACK911Labs.ca

    www.HostingSecList.com - Security Notices for the Hosting Community.

  4. #4
    Join Date
    Apr 2005
    Location
    Cochin
    Posts
    2,452
    Best solution.

    ftp your sql script to the new host and ask the support to restore it for you.


  5. #5
    Join Date
    Jan 2008
    Posts
    384
    how you are importing database from old server?

    for speed import i would recommend use wget command in ssh.

  6. #6
    If it's a one off thing, then try asking your client's host to do it for you manually.

Posting Permissions

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