Re: mysqldump from mysql 5.1.73 to mariadb 10.1.26 imports no data

2017-11-11 Thread Mark Fletcher
On Sat, Nov 11, 2017 at 11:23:37AM +0200, Tapio Lehtonen wrote: > Mark Fletcher kirjoitti 11.11.2017 klo 08:44: > > > > I'm not sure I'd expect that much newer a mysqldump client to work on > > that much older a server. And the mysql - mariadb divide won't be > > helping either (although it also

Re: mysqldump from mysql 5.1.73 to mariadb 10.1.26 imports no data

2017-11-11 Thread Tapio Lehtonen
Mark Fletcher kirjoitti 11.11.2017 klo 08:44: > On Fri, Nov 10, 2017 at 05:20:15PM +0200, Tapio Lehtonen wrote: >> I am importing databases from old host to new. Checking stuff I noticed all >> databases were created but they had no tables and no records. >> >>> Examining this I tried to run the my

Re: mysqldump from mysql 5.1.73 to mariadb 10.1.26 imports no data

2017-11-10 Thread Mark Fletcher
On Fri, Nov 10, 2017 at 05:20:15PM +0200, Tapio Lehtonen wrote: > I am importing databases from old host to new. Checking stuff I noticed all > databases were created but they had no tables and no records. > > > Examining this I tried to run the mysqldump that tries to copy the > > database from S

Re: mysqldump and special characters in the password [solved]

2006-09-02 Thread Mumia W.
On 09/01/2006 12:30 PM, Hans du Plooy wrote: On Thu, 2006-08-31 at 23:34 +0200, Hans du Plooy wrote: On Thu, 2006-08-31 at 08:06 -0500, Mumia W. wrote: mysqldump -u root [EMAIL PROTECTED] web8_db1 /home/backup/web8_db1.sql This fails. But I can log in with mysql -u root -p and then type th

Re: mysqldump and special characters in the password [solved]

2006-09-01 Thread Hans du Plooy
On Thu, 2006-08-31 at 23:34 +0200, Hans du Plooy wrote: > On Thu, 2006-08-31 at 08:06 -0500, Mumia W. wrote: > > > mysqldump -u root [EMAIL PROTECTED] web8_db1 > > >> /home/backup/web8_db1.sql > > > > > > This fails. But I can log in with mysql -u root -p and then type the > > > password in, an

Re: mysqldump and special characters in the password

2006-08-31 Thread Hans du Plooy
On Thu, 2006-08-31 at 08:06 -0500, Mumia W. wrote: > > mysqldump -u root [EMAIL PROTECTED] web8_db1 > >> /home/backup/web8_db1.sql > > > > This fails. But I can log in with mysql -u root -p and then type the > > password in, and that works. > > > > How do I get mysqldump to deal to deal with t

Re: mysqldump and special characters in the password

2006-08-31 Thread Mumia W.
On 08/31/2006 06:04 AM, Hans du Plooy wrote: Hi guys, I'm setting up a script to backup the mysql databases on a web server. For example: mysqldump -u root [EMAIL PROTECTED] web8_db1 /home/backup/web8_db1.sql This fails. But I can log in with mysql -u root -p and then type the password i

Re: mysqldump

2000-07-08 Thread Christian Hammers
Hi > does anyone know how I could do a dump of my database ( using mysqldump) but > i > want to leave out 1 specific table. mysqldump x specific > save echo "drop table specifi" | mysql x mysqldump x > bigdump mysql x < save rm save of course only if no write actions take place to the specific