Re: can't start daemon
i actually don't have anything valuable in my database, it's on my home pc. I upgraded with the standard procedure. On 6/17/06, Dan Trainor <[EMAIL PROTECTED]> wrote: Anthony Ettinger wrote: > I just upgraded to mysql 5, and can't restart the daemon. > > > 060617 11:57:22 [Warning] No argument was provided to --log-bin, and > --log-bin-index was not used; so replication may break when this MySQL > server acts as a master and has his hostname changed!! Please use > '--log-bin=spring-bin' to avoid this problem. > InnoDB: Error: log file ./ib_logfile0 is of different size 0 8388608 bytes > InnoDB: than specified in the .cnf file 0 5242880 bytes! > 060617 11:57:23 [Warning] './mysql/host' had no or invalid character > set, and default character set is multi-byte, so character column > sizes may have changed > 060617 11:57:23 [Warning] './mysql/user' had no or invalid character > set, and default character set is multi-byte, so character column > sizes may have changed > 060617 11:57:23 [Warning] './mysql/db' had no or invalid character > set, and default character set is multi-byte, so character column > sizes may have changed > 060617 11:57:23 [ERROR] Fatal error: mysql.user table is damaged or in > unsupported 3.20 format. > 060617 11:57:43 [Warning] No argument was provided to --log-bin, and > --log-bin-index was not used; so replication may break when this MySQL > server acts as a master and has his hostname changed!! Please use > '--log-bin=spring-bin' to avoid this problem. > InnoDB: Error: log file ./ib_logfile0 is of different size 0 8388608 bytes > InnoDB: than specified in the .cnf file 0 5242880 bytes! > 060617 11:57:43 [Warning] './mysql/host' had no or invalid character > set, and default character set is multi-byte, so character column > sizes may have changed > 060617 11:57:43 [Warning] './mysql/user' had no or invalid character > set, and default character set is multi-byte, so character column > sizes may have changed > 060617 11:57:43 [Warning] './mysql/db' had no or invalid character > set, and default character set is multi-byte, so character column > sizes may have changed > 060617 11:57:43 [ERROR] Fatal error: mysql.user table is damaged or in > unsupported 3.20 format. > Hi - Which version did you upgrade to? Did you follow the appropriate upgrade guides? Thanks -dant -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Anthony Ettinger Signature: http://chovy.dyndns.org/hcard.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
can't start daemon
I just upgraded to mysql 5, and can't restart the daemon. 060617 11:57:22 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=spring-bin' to avoid this problem. InnoDB: Error: log file ./ib_logfile0 is of different size 0 8388608 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 060617 11:57:23 [Warning] './mysql/host' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed 060617 11:57:23 [Warning] './mysql/user' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed 060617 11:57:23 [Warning] './mysql/db' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed 060617 11:57:23 [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format. 060617 11:57:43 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=spring-bin' to avoid this problem. InnoDB: Error: log file ./ib_logfile0 is of different size 0 8388608 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 060617 11:57:43 [Warning] './mysql/host' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed 060617 11:57:43 [Warning] './mysql/user' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed 060617 11:57:43 [Warning] './mysql/db' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed 060617 11:57:43 [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format. -- Anthony Ettinger Signature: http://chovy.dyndns.org/hcard.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: remotely show databases
On 1/9/06, Logan, David (SST - Adelaide) <[EMAIL PROTECTED]> wrote: > > True, however you could run the perl script locally via another > mechanism and allow it to return the database info in the format that > you desire, or run it using the mysql -e 'show databases' -u > local_user_that_doesn't_need_a_password > > The other option is to use an ssh tunnel to the server in question. I > use that quite a bit. Redirect a port say, 1, to 3306 locally. That > would be ok if you can ssh to it, it will also secure the communications > and allow you to extract the information that you require. > > You only then need to open the ssh port on the remote machine. From my > reading of you emails, that seems to be ok to do. > > Regards > > --- > ** _/ ** David Logan > *** _/ *** ITO Delivery Specialist - Database > *_/* Hewlett-Packard Australia Ltd > _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] > _/ _/ _/ _/ Desk: +618 8408 4273 > _/ _/ _/_/_/ Mobile: 0417 268 665 > *_/ ** > ** _/ Postal: 148 Frome Street, > _/ ** Adelaide SA 5001 > Australia > invent > ------- > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of > Anthony Ettinger > Sent: Tuesday, 10 January 2006 9:33 AM > To: Logan, David (SST - Adelaide) > Cc: Mikhail Berman; mysql@lists.mysql.com > Subject: Re: remotely show databases > > On 1/9/06, Logan, David (SST - Adelaide) <[EMAIL PROTECTED]> wrote: > > > > Hi Anthony, > > > > If you are accessing the db from perl, just execute a show databases > > from there using the DBI interface. There is quite an amount of doco > > about this and other features at cpan.org. You could also look at the > > source for phpMyadmin as this has to get the database names to display > > them. > > > > The advantage of the DBI interface is that with a tiny bit of work, it > > will probably work with Postgresql as well. > > > > You could also give SELECT permission to a specific user on all > > databases that is not passworded and this should allow you to list the > > databases without having to send a password. > > > > Regards > > > > > > --- > > ** _/ ** David Logan > > *** _/ *** ITO Delivery Specialist - Database > > *_/* Hewlett-Packard Australia Ltd > > _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] > > _/ _/ _/ _/ Desk: +618 8408 4273 > > _/ _/ _/_/_/ Mobile: 0417 268 665 > > *_/ ** > > ** _/ Postal: 148 Frome Street, > > **** _/ ** Adelaide SA 5001 > > Australia > > invent > > --- > > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of > > Anthony Ettinger > > Sent: Tuesday, 10 January 2006 7:40 AM > > To: Mikhail Berman > > Cc: mysql@lists.mysql.com > > Subject: Re: remotely show databases > > > > 'SHOW DATABASES;' | mysql -u foo -h bar.com > > > > this works, I haven't tested it with other databases though. > > > > On 1/9/06, Mikhail Berman <[EMAIL PROTECTED]> wrote: > > > > > > Hi Anthony, > > > > > > I am not sure if you have an installation of MySQL on your local > > server. > > > If you do then you can try to use something like below to execute > your > > > "SHOW DATABASES" > > > > > > Local_server>[path to your mysql/bin directory]/mysql > > > --host=your_remote_host --user=your_user --password=your_password -e > > > "SHOW DATABASE" > > > > > > Make sure that [EMAIL PROTECTED] has appropriate rights on > > > your_remote_host (server) > > > > > > Best, > > > > > > Mikhail Berman > > > > > > -Original Message- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of > > > Anthony Ettinger > > > Sent: Sunday, January 08, 2006 4:
Re: remotely show databases
On 1/9/06, Logan, David (SST - Adelaide) <[EMAIL PROTECTED]> wrote: > > Hi Anthony, > > If you are accessing the db from perl, just execute a show databases > from there using the DBI interface. There is quite an amount of doco > about this and other features at cpan.org. You could also look at the > source for phpMyadmin as this has to get the database names to display > them. > > The advantage of the DBI interface is that with a tiny bit of work, it > will probably work with Postgresql as well. > > You could also give SELECT permission to a specific user on all > databases that is not passworded and this should allow you to list the > databases without having to send a password. > > Regards > > > --- > ** _/ ** David Logan > *** _/ *** ITO Delivery Specialist - Database > *_/* Hewlett-Packard Australia Ltd > _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] > _/ _/ _/ _/ Desk: +618 8408 4273 > _/ _/ _/_/_/ Mobile: 0417 268 665 > *_/ ** > ** _/ Postal: 148 Frome Street, > _/ ** Adelaide SA 5001 > Australia > invent > --- > > -----Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of > Anthony Ettinger > Sent: Tuesday, 10 January 2006 7:40 AM > To: Mikhail Berman > Cc: mysql@lists.mysql.com > Subject: Re: remotely show databases > > 'SHOW DATABASES;' | mysql -u foo -h bar.com > > this works, I haven't tested it with other databases though. > > On 1/9/06, Mikhail Berman <[EMAIL PROTECTED]> wrote: > > > > Hi Anthony, > > > > I am not sure if you have an installation of MySQL on your local > server. > > If you do then you can try to use something like below to execute your > > "SHOW DATABASES" > > > > Local_server>[path to your mysql/bin directory]/mysql > > --host=your_remote_host --user=your_user --password=your_password -e > > "SHOW DATABASE" > > > > Make sure that [EMAIL PROTECTED] has appropriate rights on > > your_remote_host (server) > > > > Best, > > > > Mikhail Berman > > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of > > Anthony Ettinger > > Sent: Sunday, January 08, 2006 4:03 PM > > To: mysql@lists.mysql.com > > Subject: remotely show databases > > > > I know I can login via ssh and run $mysqlshow > > > > But I would then have to parse the outputted text, is there an easier > > way (I'm using Perl locally here). > > > > The pitfall of running it locally is that you DO have to password > > protect your database user since it's an outside connection to run > "SHOW > > DATABASES"; > > > > I tried $man mysqlshow, but didn't see any easy way of simply > returning > > a \n seperated list of databases. > > > > Any suggestions? > > > > I also need to do this for postgresql if anyone else knows of a > > standalone app that dumps the databases for a specific user. > > Actually, for security reasons, the command has to be executed on the remote ssh server that has network access to the mysql server. Going across the Internet with DBI; may not be feasible unless you open up the access host.
Re: remotely show databases
'SHOW DATABASES;' | mysql -u foo -h bar.com this works, I haven't tested it with other databases though. On 1/9/06, Mikhail Berman <[EMAIL PROTECTED]> wrote: > > Hi Anthony, > > I am not sure if you have an installation of MySQL on your local server. > If you do then you can try to use something like below to execute your > "SHOW DATABASES" > > Local_server>[path to your mysql/bin directory]/mysql > --host=your_remote_host --user=your_user --password=your_password -e > "SHOW DATABASE" > > Make sure that [EMAIL PROTECTED] has appropriate rights on > your_remote_host (server) > > Best, > > Mikhail Berman > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of > Anthony Ettinger > Sent: Sunday, January 08, 2006 4:03 PM > To: mysql@lists.mysql.com > Subject: remotely show databases > > I know I can login via ssh and run $mysqlshow > > But I would then have to parse the outputted text, is there an easier > way (I'm using Perl locally here). > > The pitfall of running it locally is that you DO have to password > protect your database user since it's an outside connection to run "SHOW > DATABASES"; > > I tried $man mysqlshow, but didn't see any easy way of simply returning > a \n seperated list of databases. > > Any suggestions? > > I also need to do this for postgresql if anyone else knows of a > standalone app that dumps the databases for a specific user. > > > -- > Anthony Ettinger > Signature: http://chovy.dyndns.org/hcard.html > -- Anthony Ettinger Signature: http://chovy.dyndns.org/hcard.html
remotely show databases
I know I can login via ssh and run $mysqlshow But I would then have to parse the outputted text, is there an easier way (I'm using Perl locally here). The pitfall of running it locally is that you DO have to password protect your database user since it's an outside connection to run "SHOW DATABASES"; I tried $man mysqlshow, but didn't see any easy way of simply returning a \n seperated list of databases. Any suggestions? I also need to do this for postgresql if anyone else knows of a standalone app that dumps the databases for a specific user. -- Anthony Ettinger Signature: http://chovy.dyndns.org/hcard.html
Re: mysqldump: Got errno 32 on write ?
I am, I'm running a remote command mysqldump | gzip > some file. On 1/5/06, Logan, David (SST - Adelaide) <[EMAIL PROTECTED]> wrote: > > Hi, > > Are you running mysqldump through into a pipe eg: into tar or similar? I > mention this because : > > test1=>perror 32 > System error: 32 = Broken pipe > > Regards --- > ** _/ ** David Logan > *** _/ *** ITO Delivery Specialist - Database > *_/* Hewlett-Packard Australia Ltd > _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] > _/ _/ _/ _/ Desk: +618 8408 4273 > _/ _/ _/_/_/ Mobile: 0417 268 665 > *_/ ** > ** _/ Postal: 148 Frome Street, > _/ ** Adelaide SA 5001 > Australia > invent > --- > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of > Anthony Ettinger > Sent: Friday, 6 January 2006 2:17 PM > To: mysql@lists.mysql.com > Subject: mysqldump: Got errno 32 on write ? > > "mysqldump: Got errno 32 on write" -- any ideas? I think it may >be mysqldump is not run as user, because dump dir is > 0700?? > > -- > Anthony Ettinger > Signature: http://chovy.dyndns.org/hcard.html > -- Anthony Ettinger Signature: http://chovy.dyndns.org/hcard.html
Re: mysqldump: Got errno 32 on write ?
Turns out I forgot the gzip > filename, only had | gzip filename. But the real problem here is I'm getting packet loss and loosing my connection, which is probably why I get that error 32. On 1/5/06, Anthony Ettinger <[EMAIL PROTECTED]> wrote: > > I am, I'm running a remote command mysqldump | gzip > some file. > > > On 1/5/06, Logan, David (SST - Adelaide) <[EMAIL PROTECTED]> wrote: > > > > Hi, > > > > Are you running mysqldump through into a pipe eg: into tar or similar? I > > mention this because : > > > > test1=>perror 32 > > System error: 32 = Broken pipe > > > > Regards > > > > --- > > ** _/ ** David Logan > > *** _/ *** ITO Delivery Specialist - Database > > *_/* Hewlett-Packard Australia Ltd > > _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] > > _/ _/ _/ _/ Desk: +618 8408 4273 > > _/ _/ _/_/_/ Mobile: 0417 268 665 > > *_/ ** > > ** _/ Postal: 148 Frome Street, > > _/ ** Adelaide SA 5001 > > Australia > > inve n t > > --- > > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of > > Anthony Ettinger > > Sent: Friday, 6 January 2006 2:17 PM > > To: mysql@lists.mysql.com > > Subject: mysqldump: Got errno 32 on write ? > > > > "mysqldump: Got errno 32 on write" -- any ideas? I think it may > >be mysqldump is not run as user, because dump dir is > > 0700?? > > > > -- > > Anthony Ettinger > > Signature: http://chovy.dyndns.org/hcard.html > > > > > > -- > Anthony Ettinger > Signature: http://chovy.dyndns.org/hcard.html > -- Anthony Ettinger Signature: http://chovy.dyndns.org/hcard.html
mysqldump: Got errno 32 on write ?
"mysqldump: Got errno 32 on write" -- any ideas? I think it may be mysqldump is not run as user, because dump dir is 0700?? -- Anthony Ettinger Signature: http://chovy.dyndns.org/hcard.html
Re: cannot connect to database
add a user in the table for your remote hostname or ip number. On 12/31/05, Jon Miller <[EMAIL PROTECTED]> wrote: > > I'm trying to initialize to a database on another server from a mail > server. I can telnet to it but cannot initialize the database. > The account and user exists in the database and the paasword as I've tried > it from the mysql server. > Is there another test I can do to find out exactly what is causing the > problem? The firewall is set to allow port 3307 (it the port mysql listens > on). > > Thanks > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > -- Anthony Ettinger Signature: http://chovy.dyndns.org/hcard.html
Re: Trojan Horse in MySQL
hmmm...google is null on that one too. I'd suspect that it's just a false positive, in other words, better to be safe than sorry from Norton's point of view. On 12/1/05, Gary <[EMAIL PROTECTED]> wrote: > > I have installed Apache PHP and MySQL over a year ago on a WINXP machine > and suddenly a file, presumably there all that time is found to be > infected by an upto date Norton anti virus program. > Norton does not say what trojan horse. It cannot quarantine nor delete > the file so I stopped the MySQL process and renamed the file myself. > > File is: C:\mysqldata\erqed.dll > > Anything known about this? > > please reply to [EMAIL PROTECTED] > > Gary > > -- Anthony Ettinger hCard: http://chovy.dyndns.org/hcard.html
Re: optimizing mysqldump
I tried -C (--compress), but it still took awhile, since the resulting .sql file is 218Megs. I am thinking I will have to write a function which logs into an ssh server inside the local area network that the db server is on, and hopefully the bottleneck of the internet will disappear, only locking the tables for a few seconds or mins. On 12/1/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote: > > Hello. > > mysqldump has --compress option, which can help in case > the network is the main bottleneck. > > > >I'm using the typical --opt with mysqldump, over the internet. > > >the problem I'm having is the dump takes 30 mins or so, and during that > >time, every table in the db is locked (so as not to throw it out of > >sync). > > >How can I optmize this? I'm trying to come up with a centralized > >database > >backup tool, and I do not have direct access to the database server to > >run > >it locally. > > > > Easyhorpak.com Easyhorpak.com wrote: > > Very Easy Man. > > > > Use this scripts... > > http://www.silisoftware.com/scripts/?scriptname=backupDB > > > > It 's powerful. > > > > > > > > Please feel free to reply to this email if you have additional questions > > or concerns > > ชวน จุดาบุตร > > 01-7499093 > > Manager > > Easyhorpak.com > > > > http://www.Easyhorpak.com - Find Apartment, Service Apartment, Mansion, > > Condo, Flat, Room for rent, House .. etc Thailand > > http://www.EasyHorpak.com/webdesign - บริการดูแลและออกแบบเว็บไซต์ > > http://www.EasyHorpak.com/air - > > แหล่งรวมผู้ให้บริการติดตั้งเครื่องปรับอากาศ > > http://www.EasyHorpak.com/internet - > > แหล่งรวมผู้ให้บริการติดตั้งอินเตอร์เน็ตในอพาร์ทเมนท์ > > http://www.EasyHorpak.com/software - แหล่งรวมโปรแกรมสำหรับอพาร์ทเมนท์ > > http://www.EasyHorpak.com/move - > > > > > > > > > > > >> From: Anthony Ettinger <[EMAIL PROTECTED]> > >> To: mysql@lists.mysql.com > >> Subject: optimizing mysqldump > >> Date: Wed, 30 Nov 2005 16:44:02 -0800 > >> > >> I'm using the typical --opt with mysqldump, over the internet. > >> > >> the problem I'm having is the dump takes 30 mins or so, and during that > >> time, every table in the db is locked (so as not to throw it out of > >> sync). > >> > >> How can I optmize this? I'm trying to come up with a centralized > database > >> backup tool, and I do not have direct access to the database server to > >> run > >> it locally. > >> > >> > >> > >> > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.NET http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Gleb Paharenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ><___/ www.mysql.com > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- Anthony Ettinger hCard: http://chovy.dyndns.org/hcard.html
optimizing mysqldump
I'm using the typical --opt with mysqldump, over the internet. the problem I'm having is the dump takes 30 mins or so, and during that time, every table in the db is locked (so as not to throw it out of sync). How can I optmize this? I'm trying to come up with a centralized database backup tool, and I do not have direct access to the database server to run it locally. -- Anthony Ettinger hCard: http://chovy.dyndns.org/hcard.html