Results 1 to 6 of 6
Thread: Uploading SQL Databases by FTP
-
02-25-2008, 03:56 PM #1Aspiring Evangelist
- Join Date
- Dec 2001
- Posts
- 354
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?
-
02-25-2008, 04:14 PM #2Aspiring Evangelist
- Join Date
- Dec 2001
- Posts
- 354
Hello, Please we need help ASAP on this issue. Thank you.
Last edited by Benjamin; 02-25-2008 at 04:17 PM.
-
02-25-2008, 04:21 PM #3Web Hosting Master
- Join Date
- Mar 2003
- Location
- Canada
- Posts
- 9,072
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.
-
02-26-2008, 04:18 AM #4Disabled
- 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.
-
02-26-2008, 05:51 AM #5Aspiring Evangelist
- 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.
-
02-26-2008, 08:42 AM #6Newbie
- Join Date
- Feb 2008
- Posts
- 10
If it's a one off thing, then try asking your client's host to do it for you manually.