Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Trouble importing MySQL database
Topic Options
- 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
- :
- 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
Hi
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
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
Message 1 of 8
(1,684 Views)
7 REPLIES 7
Re: Trouble importing MySQL database
14-09-2009 9:07 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Just to demonstrate that this seems to be a PlusNet issue, I had no trouble at all installing the database in exactly the same way on another server.
Tim
Tim
Message 2 of 8
(279 Views)
Re: Trouble importing MySQL database
14-09-2009 5:19 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Have you tried exporting just the tables rather than the complete database? You should be able to import the tables via phpMyAdmin.
David
Message 3 of 8
(279 Views)
Re: Trouble importing MySQL database
14-09-2009 9:17 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
I'm having exactly the same problem. It's not related to size of text file, because I've tried a file of just a couple of rows and columns, importing into a test table. I get the same error message as you.
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...
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...
Message 4 of 8
(279 Views)
Re: Trouble importing MySQL database
14-09-2009 11:21 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
i had this problem, just importing the tables seemed to work
Message 5 of 8
(279 Views)
Re: Trouble importing MySQL database
15-09-2009 1:51 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
I've not tried this at all, but if you are trying to import a database is it failing on the create database as you don't have permissions to create databases with Plusnet. You would just need to import the tables into the existing database.
Phil
Phil
Message 6 of 8
(279 Views)
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.
David
Message 7 of 8
(279 Views)
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.
Message 8 of 8
(279 Views)
Topic Options
- 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
- :
- Trouble importing MySQL database