river10 Posted February 22, 2004 Posted February 22, 2004 Hello, I just set up an account with this wonderful service and am wondering if there is anyway to upload a large mysql database. It is about 90 MB and it looks like the limit is about 50 MB. I tried using a PHP script called BigDump, but it keep erroring in the middle of the upload. Are there any other alternatives to get the mysql dump file up into a mysql database? Thanks. Quote
TCH-Rick Posted February 22, 2004 Posted February 22, 2004 You can upload the sql dump file using a standard FTP client. Let us know if you need us to import the data into a database. We can do that from the Help Desk. Quote
river10 Posted February 22, 2004 Author Posted February 22, 2004 Wow, I feel loved! Thanks for the very speedy and helpful response guys. I will send a message to the Help Desk once it's uploaded. Thanks and have a great weekend! Quote
CodeSlinger Posted September 26, 2004 Posted September 26, 2004 Or you could try a PERL script like this. Put in a .cgi file in your cgi-bin directory and set the execute permission. Then access it via HTTP. I recommend removing it after you've finished loading the SQL script for security reasons. This assumes that you've already used FTP to get the SQL script on the server. >#!/usr/bin/perl -w use strict; local $|=1; print "Content-Type: text/html\n\n"; print "<body>\n"; print "<div style='text-align:center;border:1px solid red;margin-bottom:1ex;'>Before SQL statement</div>"; # the following is all on one line until the semicolon my $zret = qx!mysql --silent --html --user="YOUR_DB_USER" --password="YOUR_DB_PASSWORD" YOUR_DB_NAME < YOUR_DB_SCRIPT.sql 2>&1 !; print $zret; print "<div style='text-align:center;border:1px solid red;margin-top:1ex;'>After SQL statement</div>"; print "</body>\n"; Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.