updates during database dump
Hi. When mysql is doing a dump, do the updates that happen during the dump get included in the dump. I have a dump that starts at 11pm and goes for 2 hours. If someone updates data at say 11:45pm, does that update get included in the dump? When does the window, on what gets included in a dump, close? Thanks. Kind regards. -- Luke Vanderfluit. Analyst/Programmer. Internode Systems Pty. Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: importing a dumpfile from with the mysql client
Hi. sheeri kritzer wrote: Ah, I get it.I don't know if there's a way to do that, but why not just put the SQL statements in the file? -Sheeri Thanks George. You're right, that's what I meant. Sheeri, it would be quite possible to put it the dumpfile, if the dumpfile was editable (-: The dumpfile we are using is so large that I can't open it with any editor. So again the question is: If the remote session is still active but I haven't carried out those commands and the database has been updated, modified, manipulated etc. in the meantime, is there a danger in closing the session or carrying out the commands several days later ? The commands that I am talking about are: > mysql> SET FOREIGN_KEY_CHECKS = 1; > mysql> COMMIT; Thanks. Kind regards. On 5/5/06, George Law <[EMAIL PROTECTED]> wrote: I think what he is saying is that be began the "transaction" in a command line client session from one location but was not able to give the > mysql> SET FOREIGN_KEY_CHECKS = 1; > mysql> COMMIT; commands in the same session. (ie - I owe, I owe, its off to work I go :) ) This is a good question, one I have wondered about myself. Is there a way in mysql to "attach" to session to issue a commit? -Original Message- From: sheeri kritzer [mailto:[EMAIL PROTECTED] Sent: Friday, May 05, 2006 3:02 PM To: Luke Vanderfluit Cc: MySQL List Subject: Re: importing a dumpfile from with the mysql client On 5/4/06, Luke Vanderfluit <[EMAIL PROTECTED]> wrote: [snip] > I started this process remotely then went to the site to finish it. > But when the dump finished (several hours later) I was not able to > execute the following commands from my original location. > > mysql> SET FOREIGN_KEY_CHECKS = 1; > mysql> COMMIT; What do you mean "you were not able"? Did you get an error? Was the server hung? Did the keyboard stick to make you unable to type the commands? > > My question is: > Since the import completed the database has grown in size and been > backed up etc. > Yet from the original session I have not executed those 2 commands. > > Is it safe to execute them? Or would executing them cause corruption or > other unforseen stuff? > Is it unnecessary to execute them? > Is it safe to kill that original mysql session? Those 2 commands, in and of themselves, aren't dangerous. It's what's in the script that could be the problem. However, since you really didn't mention what error you got, it's not easy to figure out how to fix it. It depends what tables you're running these on. If you're running them on MyISAM tables, deadlocking cannot happen. Then again, transactions are meaningless too. If you're running on InnoDB you have the possibility of deadlocking, but MySQL is pretty good about avoiding that. If other users/applications are writing to the SAME data then there's the possibility of inconsistent data, but I wouldn't expect corruption. if you post what errors you actually got, I might be able to help. Also, are you using the same db and tables that other apps/users are using? Does the dumpfile contain "DROP TABLE IF EXISTS" commands? -Sheeri > > -- > Luke Vanderfluit. > Analyst/Programmer. > Internode Systems Pty. Ltd. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Luke Vanderfluit. Analyst/Programmer. Internode Systems Pty. Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Output to a file
Hi Payne. Payne wrote: Hey, been trying to output a select statment to a file, all the books I have only show how to input from a file, what is the correct way I thought I could do select * from my_toy >> `/tmp/my_toys` You can do 'select * into outfile from ;' But I get an error. Payne -- Luke Vanderfluit. Analyst/Programmer. Internode Systems Pty. Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
importing a dumpfile from with the mysql client
Hi. I recently imported a dumpfile into mysql4.1.18 I did this using the 'source' syntax from inside the mysql client. this is syntax I used: mysql>create database dbname; mysql>use dbname; -unset the creation of bin-logs in my.cnf mysql> SET SQL_LOG_BIN = 0 then some tips to fast import dump files. mysql> SET FOREIGN_KEY_CHECKS = 0; mysql> SET AUTOCOMMIT=0; mysql> SOURCE foo.out-20060419-23 I started this process remotely then went to the site to finish it. But when the dump finished (several hours later) I was not able to execute the following commands from my original location. mysql> SET FOREIGN_KEY_CHECKS = 1; mysql> COMMIT; My question is: Since the import completed the database has grown in size and been backed up etc. Yet from the original session I have not executed those 2 commands. Is it safe to execute them? Or would executing them cause corruption or other unforseen stuff? Is it unnecessary to execute them? Is it safe to kill that original mysql session? Since the commands were executed from a single session, and the database has been extensively modified in the meantime, would executing those commands from the same original session now, cause problems? Thanks. Kind regards. Luke. -- Luke Vanderfluit. Analyst/Programmer. Internode Systems Pty. Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: innodb vs myisam
Hi. Thanks for your response> [EMAIL PROTECTED] wrote: Do you have any idexes on the table? No. The table looks like this. Would there be any advantage in creating indexes for it? | id | | LastUpdated| | 32957c615b37b5674f99d1cfd06d6a23 | | 20060416075614 | | 33d1d3a8b63c983a67ec5ab38d148774 | | 20060416003803 | | 3b0d2f1e5c2fe60377220aa146abd926 | | 20060411095312 | | 3c61d917967fb3ed45fa2ed8efb67aa8 | | 20060413150746 | | 4e0debc18ce34d8f131e05664f9df6da | | 20060411104352 | What does your mysql> show create table tbl_name \G /~ mysql> show create table sessions \G *** 1. row *** Table: sessions Create Table: CREATE TABLE `sessions` ( `id` char(32) NOT NULL, `a_session` longtext, `LastUpdated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 1 row in set (0.00 sec) mysql> \_ Thanks. Kind regards. In theory, theory and practice are the same; in practice they are not. On Thu, 13 Apr 2006, Luke Vanderfluit wrote: To: mysql@lists.mysql.com From: Luke Vanderfluit <[EMAIL PROTECTED]> Subject: innodb vs myisam Hi. I have the following myisam table: The table is only 32,000 rows, but over 60Megs in size. And mysql seems to be wanting to write to that file alot, so it may well be trying to seek all over the disk looking for the right spot all the time. Does innodb do a better job at keeping the file on the disk smaller? Does an innodb table take up less disk space than myisam? Is an innodb table compacter and would therefore require less disk seek time or I/O than myisam? Kind regards. Luke. -- Luke
innodb vs myisam
Hi. I have the following myisam table: The table is only 32,000 rows, but over 60Megs in size. And mysql seems to be wanting to write to that file alot, so it may well be trying to seek all over the disk looking for the right spot all the time. Does innodb do a better job at keeping the file on the disk smaller? Does an innodb table take up less disk space than myisam? Is an innodb table compacter and would therefore require less disk seek time or I/O than myisam? Kind regards. Luke. -- Luke -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: DBD::mysql::st execute failed: MySQL server has gone away
Ravi Prasad LR wrote: Luke, Yup. Basically if I do a particular query from the command line, I get the following error: === InnoDB: Error: tried to read 16384 bytes at offset 1 3469819904. InnoDB: Was only able to read -1. 060327 8:25:41 InnoDB: Operating system error number 5 in a file operation. InnoDB: Error number 5 means 'I/O error'. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/mysql/en/Operating_System_error_codes.html InnoDB: File operation call: 'read'. InnoDB: Cannot continue operation. 060327 08:25:41 mysqld restarted 060327 8:25:42 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 060327 8:25:42 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 2 2096716847. InnoDB: Doing recovery: scanned up to log sequence number 2 2096716847 InnoDB: Last MySQL binlog file position 0 79, file name ./ticketdb-bin.15 060327 8:25:42 InnoDB: Flushing modified pages from the buffer pool... 060327 8:25:42 InnoDB: Started; log sequence number 2 2096716847 /opt/csw/mysql4/libexec/mysqld: ready for connections. Version: '4.1.18-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution It looks like your disk is having problems.What does 'dmesg' or /var/log/messages say You're right it was the disk. Kind regards. Luke. Thanks, Ravi -- Luke
Re: DBD::mysql::st execute failed: MySQL server has gone away
Hi Sheeri. sheeri kritzer wrote: What happens if you try to connect to the database on the commandline? Yup. Basically if I do a particular query from the command line, I get the following error: === InnoDB: Error: tried to read 16384 bytes at offset 1 3469819904. InnoDB: Was only able to read -1. 060327 8:25:41 InnoDB: Operating system error number 5 in a file operation. InnoDB: Error number 5 means 'I/O error'. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/mysql/en/Operating_System_error_codes.html InnoDB: File operation call: 'read'. InnoDB: Cannot continue operation. 060327 08:25:41 mysqld restarted 060327 8:25:42 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 060327 8:25:42 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 2 2096716847. InnoDB: Doing recovery: scanned up to log sequence number 2 2096716847 InnoDB: Last MySQL binlog file position 0 79, file name ./ticketdb-bin.15 060327 8:25:42 InnoDB: Flushing modified pages from the buffer pool... 060327 8:25:42 InnoDB: Started; log sequence number 2 2096716847 /opt/csw/mysql4/libexec/mysqld: ready for connections. Version: '4.1.18-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution = Your help is appreciated. Thanks. Kind regards. Luke -Sheeri On 3/24/06, Luke Vanderfluit <[EMAIL PROTECTED]> wrote: Hi. I'm getting the following error running apache2 with modperl, mysql 4.1.18 and RT 3.4.5 *error:*DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/stow/perl-5.8.7/lib/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm line 70. *context:* *...* *66:* if ($self->{lock}) { *67:* local $self->{dbh}->{RaiseError} = 1; *68:* *69:* my $sth = $self->{dbh}->prepare_cached(q{SELECT RELEASE_LOCK(?)}, {}, 1); *70:* $sth->execute($self->{lockid}); *71:* *72:* $self->{lock} = 0; *73:* } *74:* } *...* *code stack:* /usr/local/stow/perl-5.8.7/lib/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm:70 /usr/local/stow/perl-5.8.7/lib/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm:81 /usr/local/stow/perl-5.8.7/lib/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm:87 /usr/local/stow/perl-5.8.7/lib/site_perl/5.8.7/HTML/Mason/Request.pm:1249 If anyone can help, I'd appreciate it. Kind regards. -- Luke -- Luke
DBD::mysql::st execute failed: MySQL server has gone away
Hi. I'm getting the following error running apache2 with modperl, mysql 4.1.18 and RT 3.4.5 *error:* DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/stow/perl-5.8.7/lib/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm line 70. *context:* *...* *66:* if ($self->{lock}) { *67:* local $self->{dbh}->{RaiseError} = 1; *68:* *69:* my $sth = $self->{dbh}->prepare_cached(q{SELECT RELEASE_LOCK(?)}, {}, 1); *70:* $sth->execute($self->{lockid}); *71:* *72:* $self->{lock} = 0; *73:* } *74:* } *...* *code stack:* /usr/local/stow/perl-5.8.7/lib/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm:70 /usr/local/stow/perl-5.8.7/lib/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm:81 /usr/local/stow/perl-5.8.7/lib/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm:87 /usr/local/stow/perl-5.8.7/lib/site_perl/5.8.7/HTML/Mason/Request.pm:1249 If anyone can help, I'd appreciate it. Kind regards. -- Luke
4.0.18 restore dump file 'max_allowed_packet' error
Hi. I've got mysql 4.0.18 installed on a sun X4100 running solaris. This is just a 32 bit version of mysql. I've reverted back to this version after trying mysql 5, 4.0.26 and 4.0.18 64bit. Those versions were all unstable on 64bit, that is, the server would just go away for no apparent reason. This would ofter rear it's head when importing a dump file, the dump file I need to import is around 10 GIG, but also at other unpredictable times. I have this same database running on another machine running solaris, with no problems, except speed/performance. This other machine is the one that produces the dump file I'm trying to import. It does that with the following command: /usr/local/bin/mysqldump --opt --complete-insert --max_allowed_packet=32M rt3 | bzip2 -9 > rt3.out-`date +\%Y\%m\%d-\%H`.bz2 I'm trying to restore the file on the new machine and I'm getting a 'max_allowed_packet' error: ERROR 1153 at line 162: Got a packet bigger than 'max_allowed_packet I've tried different settings for this in my.cnf, from 32 up to 1024M, and I still get the error. Is there anything I can do to remedy this? Kind regards. -- Luke -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
dropping a database to reclaim space
Hi. I have a database that is fairly large and I'm doing some testing with 2 different mysql packages, one 32-bit, one 64bit, for comparison's sake. Now I've finished with one of the dbs and I want to reclaim the disk space. I've tried deleting a few (large) tables from the database, thinking this would free up space, however the mysql/var/ibdata1 file doesn't change in size. How can I get rid of a table or even complete database to reclaim disk space? I don't really want to delete the ibdata1 file, because that will also delete the system database right? I've already tried drop database and that doesn't show reduced disk space either. I'm doing this on a solaris 9 box. Any input appreciated. Thanks. Kind regards. -- Luke -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
binlogs
Hi. I have a production server that has a whole series of -bin files. I want to get rid of them because they are consuming too much space. Can I safely delete them? Some date back to April of this year. I've seen the 'PURGE MASTER LOGS TO 'mysql-bin.0XX';' Thanks for any replies. Kind regards. -- Luke -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [rt-users] Huge Attachments table in 3.4.4
Hi. Jesse Vincent wrote: On Tue, Oct 25, 2005 at 04:14:46PM +0930, Luke Vanderfluit wrote: Hi. I have upgraded RT from 3.0.11 to 3.4.4. Mysql 4.0.18, Apache 1.3.27 (with static modperl module). The database we are using is quite large. The main problem we are having is when a user needs to comment on a ticket, the loading of a ticket can take quite a long time. This is due to mysql churning through data. I'd like to find out how to speed up this process. How do I find out what tables mysql is checking through when RT is loading the Update.html page? You might want to start with Jeremy Zawodney's 'mytop' tool. Thanks. I have installed this and it's great :-). I have found by using mysqladmin 'processlist' and by logging slowqueries that the query responsible for the slowness is this: / SELECT DISTINCT main.* FROM Users main , Principals Principals_1, ACL ACL_2, Groups Groups_3, CachedGroupMembers CachedGroupMembers_4 WHERE ((ACL_2.RightName = 'OwnTicket')) AND ((CachedGroupMembers_4.MemberId = Principals_1.id)) AND ((Groups_3.id = CachedGroupMembers_4.GroupId)) AND ((Principals_1.Disabled = '0')or(Principals_1.Disabled = '0')) AND ((Principals_1.id != '1')) AND ((main.id = Principals_1.id)) AND ( ( ACL_2.PrincipalId = Groups_3.id AND ACL_2.PrincipalType = 'Group' AND ( Groups_3.Domain = 'SystemInternal' OR Groups_3.Domain = 'UserDefined' OR Groups_3.Domain = 'ACLEquivalence')) OR ( ( (Groups_3.Domain = 'RT::Queue-Role' AND Groups_3.Instance = 23) OR ( Groups_3.Domain = 'RT::Ticket-Role' AND Groups_3.Instance = 238803) ) AND Groups_3.Type = ACL_2.PrincipalType) ) AND (ACL_2.ObjectType = 'RT::System' OR (ACL_2.ObjectType = 'RT::Queue' AND ACL_2.ObjectId = 23) )ORDER BY main.Name ASC; \ Any ideas on how to increase the speed of this query? I'm currently running RT 3.4.4 upgraded from 3.0.11 on a relatively slow box. If I run the query after a fresh restart of mysql, it takes 150 seconds (yes it's a large database :-) If I then run the following command 'optimize table Users, Principals, ACL, Groups, CachedGroupMembers;' the query takes roughly 90 seconds to complete. This is an improvement but hasn't addressed the root cause of why the query takes so long. There may be an index that I can add to the tables to improve performance to normal speed which should be around 3-5 seconds on this box. Here are the existing indexes on the tables involved in this query: / mysql> show index from Users; +---++--+--+--+---+-+--++--++-+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | +---++--+--+--+---+-+--++--++-+ | Users | 0 | PRIMARY |1 | id | A | 99402 | NULL | NULL | | BTREE | | | Users | 0 | Users1 |1 | Name | A | 99402 | NULL | NULL | | BTREE | | | Users | 1 | Users2 |1 | Name | A | 99402 | NULL | NULL | | BTREE | | | Users | 1 | Users3 |1 | id | A | 99402 | NULL | NULL | | BTREE | | | Users | 1 | Users3 |2 | EmailAddress | A | 99402 | NULL | NULL | YES | BTREE | | | Users | 1 | Users4 |1 | EmailAddress | A | 99402 | NULL | NULL | YES | BTREE | | +---++--+--+--+---+-+--++--++-+ mysql> show index from Principals; +++-+--+-+---+-+--++--++-+ | Table | Non_unique | Key_name| Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | +++-+--+-+---+-+--++--++-+ | Principals | 0 | PRIMARY |1 | id | A | 1212037 | NULL | NULL | | BTREE | | | Principals | 1 | Principals2 |1 | ObjectId| A | 1212037 | NULL | NULL | YES | BTREE
Re: [rt-users] Huge Attachments table in 3.4.4
Hi. Ruslan Zakirov wrote: On 10/25/05, Luke Vanderfluit <[EMAIL PROTECTED]> wrote: Hi. I have upgraded RT from 3.0.11 to 3.4.4. Mysql 4.0.18, Apache 1.3.27 (with static modperl module). The database we are using is quite large. The main problem we are having is when a user needs to comment on a ticket, the loading of a ticket can take quite a long time. This is due to mysql churning through data. I'd like to find out how to speed up this process. How do I find out what tables mysql is checking through when RT is loading the Update.html page? http://wiki.bestpractical.com/?Debug I changed the log level to 'alert' but got output in the log file. Stopped and started the (apache) server and mysql server. Any particular level that I should set it to? Kind regards. -- Luke
Huge table
Hi. I have upgraded RT Request Tracker. I'm using Mysql 4.0.18, Apache 1.3.27 (with static modperl module). The database we are using is quite large. The main problem we are having is that certain processes can take quite a long time. This is due to mysql churning through data. I'd like to find out how to speed up this process. How do I find out what tables mysql is checking through when RT (the application) is loading a particular page? I'm pretty sure that the lag is caused by an oversized table. Are there any suggestions on how to find out more precisely which processes are taking place during the lag? Thanks. Kind regards. -- Luke -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
copy database other than mysqldump
Hi. I'm using 4.0.18 and for legacy reasons I can't upgrade that. However I'm upgrading the database to a new schema. I want to copy the database before I make changes to the schema, so that if anything goes wrong, I can revert back. I have a dump file of the database but that is around 5GIG, so takes around an hour to restore. Is there a quicker way to copy a database other than to do a dump. Thanks. Kind regards. -- Luke -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: database won't load after machine reboot
Hi David. Logan, David (SST - Adelaide) wrote: Hi Luke, Yep, there is a procedure in the manual http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html here. This has all the steps you will need to get root back. Hope it all ends up ok! That went well (resetting the root password). Then the grant statement did the trick. Thanks. Kind regards. Luke. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Luke Vanderfluit [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 October 2005 12:17 PM To: mysql Subject: Re: database won't load after machine reboot Hi David. Thanks for your help. Logan, David (SST - Adelaide) wrote: Hi Luke, Have you tried doing another GRANT statement to ensure the name and password are indeed correct? That would be my next step. That way at least you are sure that the name/password combination are correct. I can't access the database as root anymore. Accessing as other users doesn't allow me to set any GRANT statements. Is there any way I can reset the root password? (Ouch). Kr. Luke. -- Luke
Re: database won't load after machine reboot
Hi David. Thanks for your help. Logan, David (SST - Adelaide) wrote: Hi Luke, Have you tried doing another GRANT statement to ensure the name and password are indeed correct? That would be my next step. That way at least you are sure that the name/password combination are correct. I can't access the database as root anymore. Accessing as other users doesn't allow me to set any GRANT statements. Is there any way I can reset the root password? (Ouch). Kr. Luke. -- Luke -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: database won't load after machine reboot
Hi David. Logan, David (SST - Adelaide) wrote: Hi Luke, According to the log 051019 19:46:20 mysqld started 051019 19:46:20 InnoDB: Started /myProgs/mysql/libexec/mysqld: ready for connections. Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306 mysqld is sitting there fat, dumb and happy waiting for somebody to talk to it at either /tmp/mysql.sock or on port 3306. Are you able to connect to other databases? Yes. Have you tried connecting via the mysql client and seeing if you can get to the databases that way? This would give you an error message which could help identify what the issue is. Yes. mysql -u luke -p blog ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'blog' eg. $ mysql -u -p -h -D You could run mysqlcheck -u root -p -h and this will tell you if there is any corruption in any table. Earlier in the piece you had a crash, thats fine as InnoDB did the right thing and recovered nicely (as it should) and since then the database has been restarted a few times with no issue. That's right. So mysql is fine. Just can't connect to the database name blog. I'm certain of the right username and password. So hmmm Kind regards. Luke. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Luke Vanderfluit [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 October 2005 11:45 AM To: mysql Subject: Re: database won't load after machine reboot Hi. Logan, David (SST - Adelaide) wrote: Do you have any sample of error output? This would be useful. I think the problem started where I have inserted the lines. Thanks. / = 050914 04:44:49 mysqld restarted 050914 4:44:53 InnoDB: Started /myProgs/mysql/libexec/mysqld: ready for connections. Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306 050918 0:27:35 Aborted connection 30 to db: 'unconnected' user: 'luke' host: `loc alhost' (Got timeout reading communication packets) 050923 9:01:48 Aborted connection 5931 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 050923 9:01:48 Aborted connection 5934 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 050923 9:01:48 Aborted connection 5937 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 050923 9:01:48 Aborted connection 5940 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 050923 9:01:48 Aborted connection 5943 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 050923 9:01:48 Aborted connection 5946 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 051015 14:53:20 Aborted connection 14332 to db: 'comstechIntDB' user: 'luke' host: / = `localhost' (Got an error writing communication packets) 051019 11:36:44 mysqld started 051019 11:36:44 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 6648179 InnoDB: Doing recovery: scanned up to log sequence number 0 6648179 InnoDB: Last MySQL binlog file position 0 5263271, file name ./bench-bin.015 051019 11:36:44 InnoDB: Flushing modified pages from the buffer pool... 051019 11:36:44 InnoDB: Started /myProgs/mysql/libexec/mysqld: ready for connections. Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306 051019 14:04:27 mysqld started 051019 14:04:27 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 6648179 InnoDB: Doing recovery: scanned up to log sequence number 0 6648179 InnoDB: Last MySQL binlog file position 0 5263271, file name ./bench-bin.015 051019 14:04:27 InnoDB: Flushing modified pages from the buffer pool... 051019 14:04:27 InnoDB: Started /myProgs/mysql/libexec/mysqld: ready for connections. Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306 051019 18:55:31 /myProgs/mysql/libexec/mysqld: Normal shutdown 051019 18:55:31 InnoDB: Starting shutdown... 051019 18:55:33 InnoDB: Shutdown completed 051019 18:55:33 /myProgs/mysql/lib
Re: database won't load after machine reboot
Hi. Logan, David (SST - Adelaide) wrote: Do you have any sample of error output? This would be useful. I think the problem started where I have inserted the lines. Thanks. / = 050914 04:44:49 mysqld restarted 050914 4:44:53 InnoDB: Started /myProgs/mysql/libexec/mysqld: ready for connections. Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306 050918 0:27:35 Aborted connection 30 to db: 'unconnected' user: 'luke' host: `loc alhost' (Got timeout reading communication packets) 050923 9:01:48 Aborted connection 5931 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 050923 9:01:48 Aborted connection 5934 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 050923 9:01:48 Aborted connection 5937 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 050923 9:01:48 Aborted connection 5940 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 050923 9:01:48 Aborted connection 5943 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 050923 9:01:48 Aborted connection 5946 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 051015 14:53:20 Aborted connection 14332 to db: 'comstechIntDB' user: 'luke' host: / = `localhost' (Got an error writing communication packets) 051019 11:36:44 mysqld started 051019 11:36:44 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 6648179 InnoDB: Doing recovery: scanned up to log sequence number 0 6648179 InnoDB: Last MySQL binlog file position 0 5263271, file name ./bench-bin.015 051019 11:36:44 InnoDB: Flushing modified pages from the buffer pool... 051019 11:36:44 InnoDB: Started /myProgs/mysql/libexec/mysqld: ready for connections. Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306 051019 14:04:27 mysqld started 051019 14:04:27 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 6648179 InnoDB: Doing recovery: scanned up to log sequence number 0 6648179 InnoDB: Last MySQL binlog file position 0 5263271, file name ./bench-bin.015 051019 14:04:27 InnoDB: Flushing modified pages from the buffer pool... 051019 14:04:27 InnoDB: Started /myProgs/mysql/libexec/mysqld: ready for connections. Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306 051019 18:55:31 /myProgs/mysql/libexec/mysqld: Normal shutdown 051019 18:55:31 InnoDB: Starting shutdown... 051019 18:55:33 InnoDB: Shutdown completed 051019 18:55:33 /myProgs/mysql/libexec/mysqld: Shutdown Complete 051019 18:55:33 mysqld ended 051019 19:39:17 mysqld started 051019 19:39:18 InnoDB: Started /myProgs/mysql/libexec/mysqld: ready for connections. Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306 051019 19:46:11 /myProgs/mysql/libexec/mysqld: Normal shutdown 051019 19:46:11 InnoDB: Starting shutdown... 051019 19:46:14 InnoDB: Shutdown completed 051019 19:46:14 /myProgs/mysql/libexec/mysqld: Shutdown Complete 051019 19:46:14 mysqld ended 051019 19:46:20 mysqld started 051019 19:46:20 InnoDB: Started /myProgs/mysql/libexec/mysqld: ready for connections. Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306 Thanks David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Luke Vanderfluit [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 October 2005 11:22 AM To: mysql@lists.mysql.com Subject: Re: database won't load after machine reboot Hi. For clarity, I'm running mysql 4.0.20 And I did start the mysql daemon. Luke Vanderfluit wrote: Hi. I have a database that is used with wordpress blogging software. Yesterday the server that it's running on reset itself. Since then I can't access the database. What could be going on here? Any ideas? Thanks. Kind regards. -- Luke
Re: database won't load after machine reboot
Hi. For clarity, I'm running mysql 4.0.20 And I did start the mysql daemon. Luke Vanderfluit wrote: Hi. I have a database that is used with wordpress blogging software. Yesterday the server that it's running on reset itself. Since then I can't access the database. What could be going on here? Any ideas? Thanks. Kind regards. -- Luke -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
database won't load after machine reboot
Hi. I have a database that is used with wordpress blogging software. Yesterday the server that it's running on reset itself. Since then I can't access the database. What could be going on here? Any ideas? Thanks. Kind regards. -- Luke -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
configuration directives 4.0.18
Hi. Where can I find a good explanation/description of the configuration directives for mysql as they appear in my.cnf? I've downloaded the 4.1 manual but can't seem to find a description of the directives. BTW. Is there a manual for 4.0.18 or 4.0 version? Thanks. Kind regards. -- Luke -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql install
Hi, I'm running Redhat 8.0 and I'm installing apache, php, mysql, postgres, openssl etc. my first step is to install mysql. I want it to be perl enabled, which means I have downloaded, (this is in compliance with the INSTALL BINARY doc that comes with mysql), http://www.mysql.com/doc/en/Perl_installation.html, Data-Dumper-2.101 DBI-1.18 Msql-Mysql-modules-1.2218 Data-Dumper and DBI installed OK, then I start mysql and try to install Msql-Mysql-modules. However I get an error when doing a make, the error is /usr/bin/ld: cannot find -lz collect2: ld returned 1 exit status thanks in advance christmas cheers, -- Luke Vanderfluit - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php