Am 27.08.20 um 08:19 schrieb ell...@elliotmywebguy.com:
> No reason. I stated what version I was using in my first post and even
> asked if that could have been the issue. Lesson learned.
indeed, in the middle of the post "Maybe do I need to upgrade to MariaDB
10.4.14"
the amount of bugfixes i
No reason. I stated what version I was using in my first post and even asked if that could have been the issue. Lesson learned.E.On Aug 27, 2020 2:05 AM, Reindl Harald wrote:
Am 27.08.20 um 03:30 schrieb Elliot Holden:
> Long story short, I updated MariaDB Server from 10.4.8 to 10.4.14 and
>
Am 27.08.20 um 03:30 schrieb Elliot Holden:
> Long story short, I updated MariaDB Server from 10.4.8 to 10.4.14 and
> problem solved.
what was the point using a nearly one year old version to begin with
(sorry for not realize the outfated version in the subject after your
first post)
i won't e
Thank you Benoit, Andrei, Michael, Peter and anyone else.
Long story short, I updated MariaDB Server from 10.4.8 to 10.4.14 and
problem solved.
I don't have the energy to go back and install 10.4.8 on another server
just to see if I can recreate the problem (maybe later) but lesson
learned,
>
> Also I did make a dump of just the table in question and nothing
> changed in my results. So I did
> mysqldump -u username -pPassword -h remote_hosts my_remote_database
> my_table > table_dump.sql
>
That's better take for analysis. Could you bisect table_dump.sql INSERT's
row list to find out
Thank you for the reply. Yes I tried to take another users advice and do
SHOW WARNINGS but I kinda need a little more detail how to do this. See
below:
How do I check the result of "SHOW WARNINGS"?
I did read that I can start the mysql client with --show-warnings but as
far as showing the wa
Elliot, howdy.
Thanks for narrating it pretty verbose!
I can only suggest to trace or bisect the 600 rows insertion to catch where it
fails.
Cheers,
Andrei
> H Andrei,
>
> Thanks for the reply. To answer your question when I import the my_dump.sql
> (yes it does contain
> all 600 rows in tha
H Andrei,
Thanks for the reply. To answer your question when I import the
*my_dump.sql* (yes it does contain all 600 rows in that dump file) into
a database on the MySQL server (which uses *utf8* charset) then all
works fine. All 600 rows are imported.
But when I used that same *my_dump.sq
> When I use mysqldump to backup a MySQL 5.7.8 database then import that
> database into a MariaDB
> 10.4.8 database, at least one (maybe more) of the imported tables is
> missing rows. This is a
> WordPress database and the table in question is the wp_options table. I'm
> only getti
Thanks Bernoit,
How do I check the result of "SHOW WARNINGS"?
I did read that I can start the mysql client with --show-warnings but as
far as showing the warnings when I'm importing a database or table using:
mysql -u username -pPassword --show-warnings -h localhost my_database <
my_dump.sq
Thanks Peter,
Yes I did not the character set was different so I tried your suggestion:
First I tried:
alter database my_database character set = 'utf8';
I tried the import again and I still got missing rows.
Then I tried:
drop database my_database;
create database myw_database character
Hi!
Hi!
Wed, 12 Aug 2020, 06:26 Elliot Holden, wrote:
> Hello All,
>
> New to the list, so maybe an expert has the easy answer to this one...
>
> When I use mysqldump to backup a MySQL 5.7.8 database then import that
> database into a MariaDB 10.4.8 database, at least one (maybe more) of the
> i
Hi
I suspect you've got some utf data in your MySQL and it's being excluded
with the Latin1 character set. Try creating your MariaDB database with UTF8
as it's character set.
Cheers
Peter
On Wed, 19 Aug 2020 at 14:44, Elliot Holden
wrote:
> Sending this again because I got no response the first
Hi Elliot,
You should try editing your backup file to only importing wp_options
data and check the status of the requests, when an insert execute there
is a return string which indicate how many records where created and how
many errors/warnings there where.
Then check the result of "SHOW WARNING
Sending this again because I got no response the first time and didn't
know if it was because I did something wrong protocol wise or if it was
just because no one had any idea on what my issue could be.
If anyone has a link they can point me to in either case it would be
greatly appreciated. I
Hello All,
New to the list, so maybe an expert has the easy answer to this one...
When I use mysqldump to backup a MySQL 5.7.8 database then import that
database into a MariaDB 10.4.8 database, at least one (maybe more) of
the imported tables is missing rows. This a WordPress database and the
16 matches
Mail list logo
