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

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

2017-11-11 Thread Tapio Lehtonen
mining this I tried to run the mysqldump that tries to copy the >>> database from SOURCE to TARGET. Seems it does not dump the contents of >>> the database, just some SET lines. Example below with usernames and >>> passwords edited out. This command was run on the TARGE

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 &g

mysqldump from mysql 5.1.73 to mariadb 10.1.26 imports no data

2017-11-10 Thread Tapio Lehtonen
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 SOURCE to TARGET. Seems it does not dump the contents of the database

Re: Email Issues (was: Installing mysqldump)

2013-08-16 Thread Ralf Mardorf
On Fri, 2013-08-16 at 20:51 +1200, Chris Bannister wrote: > On Wed, Aug 14, 2013 at 01:49:32AM +0200, Ralf Mardorf wrote: > > On Tue, 2013-08-13 at 17:14 -0600, Bob Proulx wrote: > > > I am sure this sounds critical. Don't take it harshly. > > > > It's helpful for Ethan. Often I don't have the ti

Re: Email Issues (was: Installing mysqldump)

2013-08-16 Thread Chris Bannister
On Wed, Aug 14, 2013 at 01:49:32AM +0200, Ralf Mardorf wrote: > On Tue, 2013-08-13 at 17:14 -0600, Bob Proulx wrote: > > I don't know how well the box drawing characters will come through > > Perfectly here :). > > > 5496 r Aug09 Ethan Rosenberg (1.2K) Installing

Re: Quoting Style Re: Installing mysqldump

2013-08-15 Thread Bob Proulx
Ethan Rosenberg, PhD wrote: > Industrial standard I think is, top quoting and styled email. Not on technical mailing lists! The standard is conversational quoting. Here are some guides that I just now found after a quick search. http://www.netmeister.org/news/learn2quote.html http://email.a

Re: Quoting Style Re: Installing mysqldump

2013-08-15 Thread Eduardo M KALINOWSKI
On Qui, 15 Ago 2013, Lisi Reisz wrote: Just set your email client up correctly. You don't need to do anything else, except trim appropriately. In the case of Icedove/Thunderbird, you don't even need to set anything[0]. By default it does correct quoting, you just have to press "Reply to li

Re: Quoting Style Re: Installing mysqldump

2013-08-15 Thread Lisi Reisz
Sorry, Ethan. I don't normally keep doing this. :-( Sent to list where it should have been in the first place. On Wednesday 14 August 2013 17:35:07 Ethan Rosenberg, PhD wrote: > Dear List - > > I appreciate your CONSTRUCTIVE criticism. I surely do not wish to have > my posts unanswered. > > Intr

Re: Quoting Style Re: Installing mysqldump

2013-08-14 Thread Klaus
On 14/08/13 18:30, Ethan Rosenberg, PhD wrote: I still do not understand and really wish to be helpful. If you could actually edit my sample, it would be DEEPLY APPRECIATED. TIA Ethan Ethan There are several aspects to this, maybe it's worth going through them one by one (this list is prob

Re: Quoting Style Re: Installing mysqldump

2013-08-14 Thread Ralf Mardorf
Hi Ethan :) now I reply to my own mail and fake that I'm you. Btw. I'm sorry the ">" signs of my example were written by hand and not done by the MUA reply option and so it seems not to work as expected. Your last mail shouldn't look like http://lists.debian.org/debian-user/2013/08/msg00503.html

Re: Quoting Style Re: Installing mysqldump

2013-08-14 Thread Ethan Rosenberg, PhD
Oops, sorry, too many cats and mice. Jerry wrote: Tom wrote: > Itchy wrote: >> Scratchy wrote: >>> I'm hungry. [snip] >> I'm too. > Let's cook Tux under the grill. No, let's eat tofu. Regards, Jerry CORRECTIONS: First SCRATCHY wrote that he's hungry, then Itchy replied to be hungry too, wh

Re: Quoting Style Re: Installing mysqldump

2013-08-14 Thread Ralf Mardorf
Oops, sorry, too many cats and mice. Jerry wrote: > Tom wrote: > > Itchy wrote: > >> Scratchy wrote: > >>> I'm hungry. [snip] > >> I'm too. > > Let's cook Tux under the grill. > > No, let's eat tofu. > > Regards, > Jerry CORRECTIONS: > First SCRATCHY wrote that he's hungry, then Itchy replied

Re: Quoting Style Re: Installing mysqldump

2013-08-14 Thread Ralf Mardorf
Tom wrote: > Itchy wrote: >> Scratchy wrote: >>> I'm hungry. [snip] >> I'm too. > Let's cook Tux under the grill. No, let's eat tofu. Regards, Jerry Explaination: First Tom wrote that he's hungry, then Itchy replied to be hungry too, while doing this Itchy snipped irrelevant content, since Tom

Re: Quoting Style Re: Installing mysqldump

2013-08-14 Thread Ralf Mardorf
Jerry wrote: > No, let's eat tofu. Hi Jerry, does it mean that we should eat veggie, or is it some kind of figure of speech for being against tofu posting style? Ciao, Ralf PS: You might notice that the ">"-sign is used no "#---" or anything else, that it can be read from to

Quoting Style Re: Installing mysqldump

2013-08-14 Thread Ethan Rosenberg, PhD
Dear List - I appreciate your CONSTRUCTIVE criticism. I surely do not wish to have my posts unanswered. Introduction - Industrial standard I think is, top quoting and styled email. This is the way my Thunderbird is set. Mail list requirements are the reverse as I well know. Therefore, I

Re: Installing mysqldump

2013-08-14 Thread Ralf Mardorf
On Wed, 2013-08-14 at 11:12 +0100, Klaus wrote: > How have you included quotes in the past? Did you manually copy and > paste them? Even that can be done, using "Edit -- Paste as Quotation" > or "Ctrl+Shift+O" . This can be done, but should be done with caution. I rarely sort my mails by thread,

Re: Installing mysqldump

2013-08-14 Thread Ralf Mardorf
On Wed, 2013-08-14 at 10:32 +0100, Lisi Reisz wrote: > Please, someone who uses Thunderbird/Icedove, come to the rescue of > the rest of us and tell Ethan how to sort his quoting out. It is, as > Bob says, painful. There isn't something to explain. I used Mozilla, Seamonkey, Thunderbird and Icedo

Re: Installing mysqldump

2013-08-14 Thread Klaus
On 14/08/13 10:32, Lisi Reisz wrote: Sorry, Ethan. On Tuesday 13 August 2013 Bob Proulx wrote: And your quoting is really painful. I am sure it is not a problem with Thunderbird since other people use it successfully. Please, someone who uses Thunderbird/Icedove, come to the rescue of the res

Re: Installing mysqldump

2013-08-14 Thread Lisi Reisz
Sorry, Ethan. On Tuesday 13 August 2013 Bob Proulx wrote: > And your quoting is really painful. I am sure it is not a > problem with Thunderbird since other people use it successfully. Please, someone who uses Thunderbird/Icedove, come to the rescue of the rest of us and tell Ethan how to sort h

Re: Installing mysqldump - SOLVED

2013-08-13 Thread Bob Proulx
Ethan Rosenberg, PhD wrote: > erased my.cnf That will have no effect at all on the problem. > purged mysql-server-5.5 > reinstalled > > IT WORKS!!! > Even my tables are there!! Yay! Bob signature.asc Description: Digital signature

Re: Installing mysqldump - SOLVED

2013-08-13 Thread Ethan Rosenberg, PhD
On 8/13/2013 6:33 PM, Bob Proulx wrote: === Dear List - I am sorry - the mysql log did not have any entries. I remember changing the local host definition to 127.0.0.1 in my.cnf I am going to erase my.cnf and see what happens. I have backed up the data files. I'll keep you

Re: Installing mysqldump

2013-08-13 Thread Ethan Rosenberg, PhD
On 8/13/2013 6:33 PM, Bob Proulx wrote: Ethan Rosenberg, PhD wrote: Reading package lists... Building dependency tree... Reading state information... 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 2 not fully installed or removed. Those two are problems that need to be fixed.

Re: Installing mysqldump

2013-08-13 Thread Jerry Stuckle
On 8/13/2013 6:33 PM, Bob Proulx wrote: Ethan Rosenberg, PhD wrote: Reading package lists... Building dependency tree... Reading state information... 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 2 not fully installed or removed. Those two are problems that need to be fixed.

Re: Email Issues (was: Installing mysqldump)

2013-08-13 Thread Ralf Mardorf
On Tue, 2013-08-13 at 17:14 -0600, Bob Proulx wrote: > I don't know how well the box drawing characters will come through Perfectly here :). > 5496 r Aug09 Ethan Rosenberg (1.2K) Installing mysqldump > 5497Aug09 Gary Roach (1.7K) ├─> > 5498Aug09 T

Email Issues (was: Installing mysqldump)

2013-08-13 Thread Bob Proulx
are garbled. Here is the structure of the discussion thread. If the chars don't come through the right side is using box drawing characters as arrows to indicate the flow of the discussion. 5496 r Aug09 Ethan Rosenberg (1.2K) Installing mysqldump 5497Aug09 Gary Roach (1.7K) ├─>

Re: Installing mysqldump

2013-08-13 Thread Bob Proulx
fter getting this fixed with mysql you can clean up the old mysql backup. And set up regular future backups. I always have this following on my systems. File /etc/cron.d/local-mysql: 30 3 * * * root umask 077 ; mysqldump --defaults-file=/etc/mysql/debian.cnf --all-databases --events |

Re: Installing mysqldump

2013-08-13 Thread Ethan Rosenberg, PhD
Ethan, I see that you are using Thunderbird. A lot of people do. But why are your messages always broken? You never reply to the message you are quoting and seem to be replying to but the message before it. Strange. And your quoting is really painful. I am sure it is not a problem with Thund

Re: Installing mysqldump

2013-08-12 Thread Bob Proulx
Ethan, I see that you are using Thunderbird. A lot of people do. But why are your messages always broken? You never reply to the message you are quoting and seem to be replying to but the message before it. Strange. And your quoting is really painful. I am sure it is not a problem with Thunde

Re: Installing mysqldump

2013-08-12 Thread Ethan Rosenberg, PhD
Ethan Rosenberg, PhD wrote: When I try to to run mysqldump, I receive the following message: ERROR 2002 can't connect to local mysql server thru socket '/var/run/mysqld/mysqld.sock' (2) That tells me that you do not have mysql running. I am a newbie and do not lhow to in

Re: Installing mysqldump

2013-08-12 Thread Bob Proulx
Ethan Rosenberg, PhD wrote: > When I try to to run mysqldump, I receive the following message: > > ERROR 2002 can't connect to local mysql server thru socket > '/var/run/mysqld/mysqld.sock' (2) That tells me that you do not have mysql running. > I am a newbie and do

Re: Installing mysqldump

2013-08-12 Thread Ethan Rosenberg, PhD
if the database is in the same PC, then you still have problems as the local mysql service is not running. check logs (syslog , mysql log) to see why its not running and attend to that. Here is part of syslog. The rest is just a repeat of the first line.. Aug 12 14:38:45 meow avah

Re: Installing mysqldump

2013-08-12 Thread The_Ace
if the database that you need to backup is not in your own PC, use the -h parameter with mysqldump and pass the host ip or fqdn of the PC in which the database resides. eg : mysqldump -h 192.168.1.30 -u username_with_external_access -p db_name > db_name.sql if the database is in the same

Re: Installing mysqldump

2013-08-11 Thread Ethan Rosenberg, PhD
= Dear List - I now have a desktop, using xfce. I now have mysqldump. The following is ABSOLUTELY CRITICAL! I have to backup a database so I can install it on another computer When I try to to run mysqldump, I receive the following message: ERROR 2002 can't connect to local mysql serve

Re: Installing mysqldump

2013-08-11 Thread Ethan Rosenberg, PhD
On Sunday 11 August 2013 19:58:14 Ethan Rosenberg, PhD wrote: Here is my sources file -- [snip many commented out lines] deb http://ftp.debian.org/debian/ wheezy-updates main contrib #deb-src http://ftp.debian.org/debian/ wheezy-updates main contrib deb http://ftp.us.debian.org/debian/ wheezy

Re: Installing mysqldump

2013-08-11 Thread Lisi Reisz
Reposting to list, where it should have gone in the first place. :-( Sorry, again, Ethan. On Sunday 11 August 2013 19:58:14 Ethan Rosenberg, PhD wrote: > Here is my sources file -- [snip many commented out lines] > deb http://ftp.debian.org/debian/ wheezy-updates main contrib > #deb-src http://

Re: Installing mysqldump

2013-08-11 Thread Ethan Rosenberg, PhD
On Friday 09 August 2013 19:51:25 Bob Proulx wrote: Ethan Rosenberg, PhD wrote: > I am trying to install mysqldump. Something is broken in your sources.list file. Fix it first. A month ago Ethan had both Squeeze DVDs and wheezy http's enabled simultaneously in his sources.list

Re: Installing mysqldump

2013-08-11 Thread Ethan Rosenberg, PhD
On 08/09/2013 08:05 AM, Ethan Rosenberg, PhD wrote: Dear List - I am trying to install mysqldump. Here is what I get - apt-get install mysql-client-5.5 Reading package lists... Building dependency tree... Reading state information... You might want to run 'apt-get -f instal

Re: Installing mysqldump

2013-08-10 Thread Lisi Reisz
On Friday 09 August 2013 19:51:25 Bob Proulx wrote: > Ethan Rosenberg, PhD wrote: > > I am trying to install mysqldump. > > Something is broken in your sources.list file. Fix it first. A month ago Ethan had both Squeeze DVDs and wheezy http's enabled simultaneously in h

Re: Installing mysqldump

2013-08-09 Thread Bob Proulx
Ethan Rosenberg, PhD wrote: > I am trying to install mysqldump. Please install "mysql-server". That will install mysqldump. Since you don't have mysqldump I can only assume that you were never able to install the mysql server. apt-get update apt-get install mysql-server

Re: Installing mysqldump

2013-08-09 Thread Gary Roach
On 08/09/2013 08:05 AM, Ethan Rosenberg, PhD wrote: Dear List - I am trying to install mysqldump. Here is what I get - apt-get install mysql-client-5.5 Reading package lists... Building dependency tree... Reading state information... You might want to run 'apt-get -f instal

Installing mysqldump

2013-08-09 Thread Ethan Rosenberg, PhD
Dear List - I am trying to install mysqldump. Here is what I get - apt-get install mysql-client-5.5 Reading package lists... Building dependency tree... Reading state information... You might want to run 'apt-get -f install' to correct these: The following packages

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

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 roo

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

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 pas

mysqldump and special characters in the password

2006-08-31 Thread Hans du Plooy
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 in, and that works. How do I get m

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 wri

mysqldump

2000-07-05 Thread Clinton Byrne
Hi there does anyone know how I could do a dump of my database ( using mysqldump) but i want to leave out 1 specific table. Any help would be great Thanks Clinton