Hi List, This is a request for your experiences with mysqldump - or more specifically loading the dump file.
I have a newly developed app that has some 30+ tables, most with few records at this time. However, it does contain a streets table with some 43K records.
I regularly dump the database using
mysqldump -u rkampen -p databasename >databasenamedatetime.sql
and load it onto other machines via
mysql -u rkampen -p -D databasename <databasenamedatetime.sql
This has always served me well on different versions of CentOS and MySql. The file is over 3,000,000 characters in just over 1,000 lines (2.7M).
Now I am needing to load this database file onto a debian host running Plesk 9.5.4 via their system admin and it is unreliable - after four attempts we have all except the streets table loaded - but this table will not load.
Thus my questions are 1. Anyone ever have this kind of problem - i.e. failure to load a mysqldump file?
2. Are there alternative methods or formats I could use?
I do not want to code something specific to dump this one record at a time and then load it one record at a time......:-( TIA for your insights Rob
On 11/27/12 12:53 PM, Rob Kampen wrote:
Now I am needing to load this database file onto a debian host running Plesk 9.5.4 via their system admin and it is unreliable - after four attempts we have all except the streets table loaded - but this table will not load.
Thus my questions are
- Anyone ever have this kind of problem - i.e. failure to load a
mysqldump file?
which part of that has ANYthing to do with CentOS ?
On 11/27/2012 10:58 PM, John R Pierce wrote:
On 11/27/12 12:53 PM, Rob Kampen wrote:
Now I am needing to load this database file onto a debian host running Plesk 9.5.4 via their system admin and it is unreliable - after four attempts we have all except the streets table loaded - but this table will not load.
Thus my questions are
- Anyone ever have this kind of problem - i.e. failure to load a
mysqldump file?
which part of that has ANYthing to do with CentOS ?
Hi, it seems normal,
There must be shown you which line is mistake...
May you have triggers in your table.
mysqldump -u rkampen -p --skip-triggers --databases databasename > databasenamedate_format.sql
test without triggers. Regards
Hello Rob,
On Wed, 2012-11-28 at 09:53 +1300, Rob Kampen wrote:
Now I am needing to load this database file onto a debian host running Plesk 9.5.4 via their system admin and it is unreliable - after four attempts we have all except the streets table loaded - but this table will not load.
Perhaps a file upload/post size limitation? Maximum execution time limit? You should ask your provider.
A workaround could be to cut the dump up using text editor and try doing it in parts.
Regards, Leonard.
On Tue, November 27, 2012 3:53 pm, Rob Kampen wrote: <snip>
I have a newly developed app that has some 30+ tables, most with few records at this time. However, it does contain a streets table with some 43K records.
I regularly dump the database using
mysqldump -u rkampen -p databasename >databasenamedatetime.sql
and load it onto other machines via
mysql -u rkampen -p -D databasename <databasenamedatetime.sql
<snip>
Now I am needing to load this database file onto a debian host running Plesk 9.5.4 via their system admin and it is unreliable - after four attempts we have all except the streets table loaded - but this table will not load.
Rob,
I have experienced a similar problem a few months back between two different versions of mySQL, both running on CentOS 5. The problem was caused by mysqldump writing a bad CREATE TABLE statement into the dump file for one of the tables. More specifically, one column had to small of a size allocated to it (and definitely different than what was in the originating database) so the import kept failing because UTF-8 characters could not fit into it. Manually fixing the size in the dump file took care of the problem.
Marko
1. as John notes, this is off-topic 2. did you notice that you give *no* information about the problem? (no, "failure to load" is not a problem description.)
Kai
On 11/28/2012 10:40 PM, Kai Schaetzl wrote:
- as John notes, this is off-topic
- did you notice that you give *no* information about the problem? (no,
"failure to load" is not a problem description.)
Certainly aware it is off topic, however this list has many participants that have extensive experience in the area I'm inquiring about. My questions relate to general issues, not a specific fix, however there have already been two replies that relate to similar results and possible causes. As mentioned in my post, I am not the one doing the load - it is another admin, and he assures me there is no message, it simply aborts. At this time I have no access other than FTP to load php scripts for the application. I have loaded the problem .sql file into two different CentOS machines, one 5.8 and the other 6.3 and have no issues, thus the items mentioned in the two other posts give me things to ask the other admin about.
Many thanks for the suggestions. Rob
Kai
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
On Wed, Nov 28, 2012 at 10:58:35PM +1300, Rob Kampen wrote:
I have loaded the problem .sql file into two different CentOS machines, one 5.8 and the other 6.3 and have no issues, thus the items mentioned in the two other posts give me things to ask the other admin about.
The target box is running Plesk. All bets are off in this instance.
John
On 11/28/12 1:58 AM, Rob Kampen wrote:
Certainly aware it is off topic, however this list has many participants that have extensive experience in the area I'm inquiring about.
so? shall we talk about cars? I bet a bunch of us drive. how about food? most everyone here eats!
I bet a rather large number of us have zero knowlege of your specific plesk-on-debian configuration. plesk is not a centos component, and debian certainly isn't centos. I'd suggest taking this up on a plesk or mysql list, or better yet, as previously suggested, with whomever is providing this plesk based hosting environment, as they are the only ones familiar with the actual configuration.
From: Rob Kampen rkampen@reaching-clients.com
As mentioned in my post, I am not the one doing the load - it is another admin, and he assures me there is no message, it simply aborts. At this time I have no access other than FTP to load php scripts for the application.
Maybe upload the sql file with FTP and ask the other admin to load the file from the cmdline. Also, google says: "Customers could not import SQL databases using phpMyAdmin with the error "No database selected" if the SQL file did not contain the command use <db name>." But yes, you should ask your question to plesk people...
JD
-
John Doe -
John R Pierce -
John R. Dennison -
Kai Schaetzl -
Leonard den Ottolander -
Marko A. Jennings -
Mustafa Demirci -
Rob Kampen