maria-discuss team mailing list archive

[Elliot Holden <elliot@xxxxxxxxxxxxxxxxxx>]

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.sql


I got no warnings when using the above command.

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


Thank you for the help

E.

On 8/19/20 4:45 AM, Benoit Plessis wrote:
> 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 WARNINGS" and "|SHOW INNODB STATUS"|
> |
> |
> |Also the "--opt" should be the default in mysqldump but you could 
> verify that your sql dump file does have charset setup and everything
> |
>
> Regards,
>
> On 19/08/2020 06:44, Elliot Holden 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
> > > https://www.ElliotMyWebGuy.com
> > --
> > Elliot Holden
> > ‪(404)884-8593‬
> > elliot@xxxxxxxxxxxxxxxxxx
> > https://www.ElliotMyWebGuy.com
> >
> > _______________________________________________
> > Mailing list:https://launchpad.net/~maria-discuss
> > Post to     :maria-discuss@xxxxxxxxxxxxxxxxxxx
> > Unsubscribe :https://launchpad.net/~maria-discuss
> > More help   :https://help.launchpad.net/ListHelp
--
Elliot Holden
‪(404)884-8593‬
elliot@xxxxxxxxxxxxxxxxxx
https://www.ElliotMyWebGuy.com