maria-discuss team mailing list archive

[Elliot Holden <elliot@xxxxxxxxxxxxxxxxxx>]

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 set = 'utf8';


Again, I tried the import and I still got missing rows.


Also tried stopping and restarting the mariadb daemon and did the import 
again to no avail.


E.



On 8/19/20 5:27 AM, Peter McLarty wrote:
> 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 <elliot@xxxxxxxxxxxxxxxxxx 
> <mailto:elliot@xxxxxxxxxxxxxxxxxx>> wrote:
>
>     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 will keep searching as well.
>
>     Thanks
>
>
>     E.
>
>     On 8/11/20 11:25 PM, 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 imported tables is missing rows. This is a WordPress
> >     database and the table in question is the *wp_options* table. I'm
> >     only getting 29 rows imported when there should be over 600 (in
> >     the original MySQL database).
> >
> >     I'm using the *mysqldump* and *mysql* utilities located on the
> >     MariaDB server:
> >
> >     mysqldump  Ver 10.17 Distrib 10.4.8-MariaDB, for Linux (x86_64)
> >     mysql  Ver 15.1 Distrib 10.4.8-MariaDB, for Linux (x86_64) using
> >     readline 5.1
> >
> >
> >     My steps as performed on the MariaDB server (the server I'm
> >     importing to).
> >
> >     1. mysqldump -u username -pPassword -h remote_mysql_server
> >     database_name > wp_backup.sql
> >
> >     2.mysql -u username -pPassword -h localhost database_name <
> >     wp_backup.sql
> >
> >     _*
> >     *_
> >
> >     When I run *mysql* (on the local MariaDB server) and import the
> >     wp_backup.sql to the remote_mysql_server everything works fine
> >     and all rows are importing into a test database out there_*:*_
> >
> >     mysql -u username -pPassword -h remote_mysql_server database_name
> >     < wp_backup.sql
> >
> >     So the above works
> >
> >
> >     I know I'm probably missing something simple but just don't
> >     know... they both seem to use the same InnoDB engine. I did
> >     notice the Db character set is different between the databases
> >     though (highlighted in blue below).
> >
> >     Maybe do I need to upgrade to MariaDB *10.4.14*
> >
> >     Any help would be greatly appreciated.....?
> >
> >
> >     Details about each server listed below:
> >
> >     _*
> >     *_
> >
> >     _*MySQL*_
> >
> >     Server version:        5.7.28-log Source distribution
> >     Protocol version:    10
> >     Server characterset:    latin1
> >     Db     characterset:    utf8
> >     Client characterset:    utf8
> >     Conn.  characterset:    utf8
> >
> >     *************************** 1. row ***************************
> >           Engine: InnoDB
> >          Support: DEFAULT
> >          Comment: Supports transactions, row-level locking, and
> >     foreign keys
> >     Transactions: YES
> >               XA: YES
> >       Savepoints: YES
> >
> >     _*
> >     *__*MariaDB*_
> >
> >     Server version:        5.5.5-10.4.8-MariaDB MariaDB Server
> >     Protocol version:    10
> >     Server characterset:    latin1
> >     Db     characterset:    latin1
> >     Client characterset:    utf8
> >     Conn.  characterset:    utf8
> >
> >     *************************** 7. row ***************************
> >           Engine: InnoDB
> >          Support: DEFAULT
> >          Comment: Supports transactions, row-level locking, foreign
> >     keys and encryption for tables
> >     Transactions: YES
> >               XA: YES
> >       Savepoints: YES
> >
> >     -- 
> >     Elliot Holden
> >     ‪(404)884-8593‬
> >     elliot@xxxxxxxxxxxxxxxxxx  <mailto:elliot@xxxxxxxxxxxxxxxxxx>
> >     https://www.ElliotMyWebGuy.com
>
>     -- 
>     Elliot Holden
>     ‪(404)884-8593‬
>     elliot@xxxxxxxxxxxxxxxxxx  <mailto:elliot@xxxxxxxxxxxxxxxxxx>
>     https://www.ElliotMyWebGuy.com
>
>     _______________________________________________
>     Mailing list: https://launchpad.net/~maria-discuss
>     Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
>     <mailto:maria-discuss@xxxxxxxxxxxxxxxxxxx>
>     Unsubscribe : https://launchpad.net/~maria-discuss
>     More help   : https://help.launchpad.net/ListHelp
>
>
>
> --
> Peter McLarty
> Leader and Technologist
> 0402094238
> http://petermclarty.setmore.com/
--
Elliot Holden
‪(404)884-8593‬
elliot@xxxxxxxxxxxxxxxxxx
https://www.ElliotMyWebGuy.com