Trouble importing MySQL database
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Help with my Plusnet services
- :
- Everything else
- :
- Re: Trouble importing MySQL database
Trouble importing MySQL database
13-09-2009 11:50 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
I've created a Joomla site at home, exported the MySQL database as a .txt file and now can't import it into my empty PlusNet database through PHPMyAdmin. I've tried halving the number of tables to reduce file size and have tried exporting the exported DB as a .zip file which makes it just 48Kb in size. I keep getting the same error message of "No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration. See FAQ 1.16".
Grateful for any ideas!
Thanks
Tim
Re: Trouble importing MySQL database
14-09-2009 9:07 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Tim
Re: Trouble importing MySQL database
14-09-2009 5:19 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Re: Trouble importing MySQL database
14-09-2009 9:17 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
See http://community.plus.net/forum/index.php/topic,79341.0.html for further details.
People on other forums say "Just use the Import facility of MyPHPAdmin" which suggests that normally it works, but that PlusNet have not set it up properly. I've seen reference to needing additional privileges for importing data compared with being able to add data one row at a time interactively in MyPHPAdmin.
Everything worked fine until PlusNet turned off Telnet and SSH access to their MySQL server - I used to ftp the tab-separated file to the server, then log on and do a Load Data Infile. But they've withdrawn access while they sort out a security issue, so I've been unable to upload the tables used by my dynamic sites for nearly a month...
Re: Trouble importing MySQL database
14-09-2009 11:21 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Re: Trouble importing MySQL database
15-09-2009 1:51 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Phil
Superusers are not staff, but they do have a direct line of communication into the business in order to raise issues, concerns and feedback from the community.
Re: Trouble importing MySQL database
16-09-2009 2:45 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Quote from: undertrees Everything worked fine until PlusNet turned off Telnet and SSH access to their MySQL server - I used to ftp the tab-separated file to the server, then log on and do a Load Data Infile. But they've withdrawn access while they sort out a security issue, so I've been unable to upload the tables used by my dynamic sites for nearly a month...
Does the following work for you (more options will be needed if it is a CSV rather than a tab-separated text file)?
Quote from: spraxyt However I think running the command within a PHP program on CCGI should work.
The steps would be
(1) FTP the text file to the same directory as the PHP program
Within the PHP program
(2) Connect to the database
(3) $load_query = "LOAD DATA LOCAL INFILE 'nameoffile.txt' INTO TABLE nameoftable";
(4) $result = mysql_query($load_query);
(5) if ($result) {echo "table loaded successfully";}
else {echo "loading failed< br / >\n", mysql_error();}
Run the program in the browser as for a normal PHP program.
Re: Trouble importing MySQL database
07-10-2009 11:51 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Quote from: spraxyt
Quote from: undertrees Everything worked fine until PlusNet turned off Telnet and SSH access to their MySQL server - I used to ftp the tab-separated file to the server, then log on and do a Load Data Infile. But they've withdrawn access while they sort out a security issue, so I've been unable to upload the tables used by my dynamic sites for nearly a month...
Does the following work for you (more options will be needed if it is a CSV rather than a tab-separated text file)?
Quote from: spraxyt However I think running the command within a PHP program on CCGI should work.
The steps would be
(1) FTP the text file to the same directory as the PHP program
Within the PHP program
(2) Connect to the database
(3) $load_query = "LOAD DATA LOCAL INFILE 'nameoffile.txt' INTO TABLE nameoftable";
(4) $result = mysql_query($load_query);
(5) if ($result) {echo "table loaded successfully";}
else {echo "loading failed< br / >\n", mysql_error();}
Run the program in the browser as for a normal PHP program.
This code does work. Normal service has been resumed: it is now possible to populate MySQL tables from CSV/TSV files again! Running a PHPscript is a perfectly good substitute for telnetting or SSHing to the server and running the LOAD DATA command from there.
PHPMyAdmin is also able to import now: in plusnet.service.customer-feedback, in the thread "Uploading data to an SQL database from a CSV file while Telnet access is turned off" Bob Pullen posted on 6 October at 14:36 to say that they had just built a new trial version of PHPMyAdmin. Unlike the old one, this can import CSV data. So there was a problem with the old version of PHPMyAdmin.
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Help with my Plusnet services
- :
- Everything else
- :
- Re: Trouble importing MySQL database