RE: Finding gaps
Thanks for the suggestion. Unfortunately that doesn't fit my need, because I need to go back in time. From: Moon's Father [mailto:[EMAIL PROTECTED] Sent: Saturday, October 25, 2008 2:57 AM To: Jerry Schwartz Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: Re: Finding gaps Create an extra trigger on that table with delete event.Then the deleted item will be recorded in the database. On Fri, Oct 10, 2008 at 11:34 PM, Jerry Schwartz [EMAIL PROTECTED] wrote: Thanks. Although I've been around SQL for quite a while, I've never really gotten the hang of self-joins. From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2008 8:22 PM To: US Data Export; mysql@lists.mysql.com Subject: Re: Finding gaps Jerry, Here is a workaround for 4.1.22: SELECT a.id+1 AS 'Missing From', MIN(b.id) - 1 AS 'To' FROM tbl AS a, tbl AS b WHERE a.id b.id GROUP BY a.id HAVING `Missing From` MIN(b.id); +--+--+ | Missing From | To | +--+--+ |3 |3 | |5 | 17 | +--+--+ PB US Data Export wrote: Well, 5.x accepted the query. It's been running for awhile, now, so I'll find out later if it did what I need. -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2008 5:25 PM To: Jerry Schwartz; mysql@lists.mysql.com Subject: Re: Finding gaps I must be missing something obvious; or does this not work in 4.1.22? Looks like a 4.1.22 bug. PB Jerry Schwartz wrote: I'm finally getting back to this issue, and I've read the bits on artfulsoftware. The example SELECT a.id+1 AS 'Missing From', MIN(b.id) - 1 AS 'To' FROM tbl AS a, tbl AS b WHERE a.id b.id GROUP BY a.id HAVING a.id MIN(b.id) - 1; Looks like exactly what I want. However, when I try it (prod is my tbl, prod_num is my id) I get mysql select a.prod_num + 1 AS `Missing From`, - MIN(b.prod_num - 1) AS `To` - from prod as a, prod as b - where a.prod_num b.prod_num - group by a.prod_num - having a.prod_num min(b.prod_num) -1 ; ERROR 1054 (42S22): Unknown column 'a.prod_num' in 'having clause' I must be missing something obvious; or does this not work in 4.1.22? Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 5:26 PM To: Stut; mysql@lists.mysql.com Subject: Re: Finding gaps Is there any elegant way of finding the gaps? You'll find some ideas under (and near) Find missing numbers in a sequence at http://www.artfulsoftware.com/infotree/queries.php. PB - Stut wrote: On 17 Sep 2008, at 22:12, Jerry Schwartz wrote: I have records that should be sequentially (not auto-increment) numbered, but there are gaps. Is there any elegant way of finding the gaps? Why do they need to be sequential? When this requirement comes up it's usually for illogical reasons. -Stut -- -- No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.169 / Virus Database: 270.6.21/1677 - Release Date: 9/17/2008 5:07 PM -- -- No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.173 / Virus Database: 270.7.6/1713 - Release Date: 10/7/2008 6:40 PM _ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.173 / Virus Database: 270.7.6/1713 - Release Date: 10/7/2008 6:40 PM -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
MySQL University session on October 30: Quick and Easy Testing With MySQL Sandbox
The next MySQL University session will take place this Thursday, 30th October. Giuseppe Maxia will get you up to speed with using MySQL Sandbox for quick and easy testing of MySQL. This session will start at 15:00 Central European Time (14:00 UTC, 14:00 BST). MySQL University is an educational program run virtually on the 'net. Sessions are open to anyone. MySQL University focuses on MySQL internals and on Sun technology that can be used in connection with MySQL, but we're open to hear your suggestions for other topics. We'll be using the Dimdim conferencing system for this session. Dimdim has integrated voice streaming and chat. To attend, you need a browser with a recent Flash plugin. You may register a Dimdim account but you don't have to. The virtual meeting room will be opened about 15 minutes before the hour. Point your browser to this address: http://webmeeting.dimdim.com/portal/[EMAIL PROTECTED] Related URLs: - MySQL University: http://forge.mysql.com/wiki/MySQL_University - http://forge.mysql.com/wiki/Quick_and_Easy_Testing_With_MySQL_Sandbox -Stefan -- *** Sun Microsystems GmbHStefan Hinz Sonnenallee 1Manager Documentation, Database Group 85551 Kirchheim-Heimstetten Phone: +49-30-82702940 Germany Fax: +49-30-82702941 http://www.sun.de/mysql mailto: [EMAIL PROTECTED] Amtsgericht Muenchen: HRB161028 Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer Vorsitzender des Aufsichtsrates: Martin Haering *** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 5.1.29-rc has been released
Dear MySQL users, We are proud to present to you the MySQL Server 5.1.29-rc release, a new release candidate version of the popular open source database. Bear in mind that this is still a candidate release, and as with any other pre-production release, caution should be taken when installing on production level systems or systems with critical data. For production level systems using 5.0, we would like to direct your attention to the product description of MySQL Enterprise at: http://mysql.com/products/enterprise/ The MySQL 5.1.29-rc release is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloads/ and mirror sites. Note that not all mirror sites may be up to date at this point in time, so if you can't find this version on some mirror, please try again later or choose another download site. We welcome and appreciate your feedback, bug reports, bug fixes, patches etc.: http://forge.mysql.com/wiki/Contributing The following section lists the changes from version to version in the MySQL source code since the latest released version of MySQL 5.1, the MySQL 5.1.28-rc release. It can also be viewed online at http://dev.mysql.com/doc/refman/5.1/en/news-5-1-29.html Sincerely, Kent Boortz The MySQL build team at Sun Microsystems === Functionality added or changed: * Important Change: The --skip-thread-priority option is now deprecated in MySQL 5.1 and is removed in MySQL 6.0 such that the server won't change the thread priorities by default. Giving threads different priorities might yield marginal improvements in some platforms (where it actually works), but it might instead cause significant degradation depending on the thread count and number of processors. Meddling with the thread priorities is a not a safe bet as it is very dependent on the behavior of the CPU scheduler and system where MySQL is being run. (Bug#35164: http://bugs.mysql.com/35164, Bug#37536: http://bugs.mysql.com/37536) * Important Change: The --log option now is deprecated and will be removed (along with the log system variable) in the future. Instead, use the --general_log option to enable the general query log and the --general_log_file=file_name option to set the general query log filename. The values of these options are available in the general_log and general_log_file system variables, which can be changed at runtime. Similar changes were made for the --log-slow-queries option and log_slow_queries system variable. You should use the --slow_query_log and --slow_query_log_file=file_name options instead (and the slow_query_log and slow_query_log_file system variables). * The SHOW PROFILES and SHOW PROFILE statements were added to display statement profile data, and the accompanying INFORMATION_SCHEMA.PROFILING table. Profiling is controlled via the 'profiling' and 'profiling_history_size' session variables. (Community contribution by Jeremy Cole) * The BUILD/compile-solaris-* scripts now compile MySQL with the mtmalloc library rather than malloc. (Bug#38727: http://bugs.mysql.com/38727) Bugs fixed: * Incompatible Change: Replication: The default binary logging mode has been changed from MIXED to STATEMENT for compatibility with MySQL 5.0. (Bug#39812: http://bugs.mysql.com/39812) * Incompatible Change: In connection with view creation, the server created arc directories inside database directories and maintained useless copies of .frm files there. Creation and renaming procedures of those copies as well as creation of arc directories has been discontinued. This change does cause a problem when downgrading to older server versions which manifests itself under these circumstances: 1. Create a view v_orig in MySQL 5.1.29 or higher. 2. Rename the view to v_new and then back to v_orig. 3. Downgrade to an older 5.1.x server and run mysql_upgrade. 4. Try to rename v_orig to v_new again. This operation fails. As a workaround to avoid this problem, use either of these approaches: + Dump your data using mysqldump before downgrading and reload the dump file after downgrading. + Instead of renaming a view after the downgrade, drop it and recreate it. (Bug#17823: http://bugs.mysql.com/17823) See also Bug#40021: http://bugs.mysql.com/40021 * Important Change: Replication: The SUPER privilege is now required to change the session value of binlog_format as well as its global value. For more information about binlog_format, see Section 15.1.2, Replication Formats. (Bug#39106: http://bugs.mysql.com/39106) * Partitioning: Replication: Replication to partitioned MyISAM tables could be slow with row-based binary
Re: Any easier way to compare mysql schema of 50 databases?!
Just use command line tools called fc on windows or diff on linux if you are patient and perfer trouble. On Tue, Oct 7, 2008 at 10:07 PM, Duzenbury, Rich [EMAIL PROTECTED]wrote: I just used mysqldiff for a project, and was successful. -Original Message- From: Uma Bhat [mailto:[EMAIL PROTECTED] Sent: Monday, October 06, 2008 7:51 PM To: Andy Shellam; mysql@lists.mysql.com Subject: Re: Any easier way to compare mysql schema of 50 databases?! Thank you all, guys!! i shall try these and respond on which worked best for me. Regards, Uma On 10/6/08, Andy Shellam [EMAIL PROTECTED] wrote: Hi, I was also going to go down this route some time back, but then when I looked at it, it's pretty simple how it works and you can do the same thing yourself for free. Take a dump of both servers (mysqldump or via MySQL Administrator) of the databases in question, then use WinMerge (for free) to compare the dump files and (optionally) create a 3rd file which is a result of merging the 2 by choosing the changes you want to keep. I've used this method plenty of times to synchronise changes between servers, some that concern 000s of rows of data. Granted you cannot do this with PostgreSQL as those dumps tend to be in binary format, but it works well for MySQL backups. WinMerge: http://www.winmerge.org/ Andy D. Dante Lorenso wrote: Uma Bhat wrote: We are in progress of *optimizing* and designing the existing mysql database enviromnent on *linux*. And need help in comaparing schema of 50 databases from the same mysql instance. If you can afford to spend a few dollars to get the right tool, you want to get DB Comparer for MySQL from the folks at EMS: http://www.sqlmanager.net/en/products/mysql/dbcomparer This tool will compare the schemas of 2 MySQL Databases and allow you to selectively choose which changes to make in order to synch to the master or the target DB. I've been using the PostgreSQL version of this tool for many years and just recently started using their MySQL one. -- Dante -- D. Dante Lorenso [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] -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
Re: Getting more info from show full processlist
I also want to know the answer to this question.If it's for me.I'll scan all the source code manually.But it's too complicated. On Tue, Oct 7, 2008 at 1:02 AM, Olaf Stein [EMAIL PROTECTED] wrote: It specifies the query in the Info field. In your case the connection is sleeping, nothing is being executed at the moment, therefore info is NULL Olaf On 10/6/08 11:38 AM, MaBa.listas [EMAIL PROTECTED] wrote: Hello, reading the MySQL documentation I've run into the show full processlist\G command. In my case I've got an output similar to this: -- --- mysql show full processlist\G *** 1. row *** Id: 30127 User: root Host: localhost db: NULL Command: Query Time: 0 State: NULL Info: show full processlist *** 2. row *** Id: 30399 User: root Host: localhost db: this would be my DB Command: Sleep Time: 0 State: Info: NULL -- --- What I'd like to know is how to get more info about the query identified with 30399 (in this example). I mean, the exact query, like SELECT pr1, pr2 FROM someDB. Thanks Matias - Confidentiality Notice: The following mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. The recipient is responsible to maintain the confidentiality of this information and to use the information only for authorized purposes. If you are not the intended recipient (or authorized to receive information for the intended recipient), you are hereby notified that any review, use, disclosure, distribution, copying, printing, or action taken in reliance on the contents of this e-mail is strictly prohibited. If you have received this communication in error, please notify us immediately by reply e-mail and destroy all copies of the original message. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
Re: Changing the location of my.ini and the order option files are read
I advise that you should put your my.cnf in mysql installation location. On Mon, Oct 6, 2008 at 11:06 PM, Varuna Seneviratna [EMAIL PROTECTED] wrote: Armin I did what you said, now I understand what you say that there is no sence in what I wanted to do.But I gave these commands as follows But it did not work.What I want is to specify a configuration file which is placed in the WINDOWS directory.The commands I ran C:\NET STOP MySQL C:\mysqld-nt --remove C:\mysqld-nt --install MYSQL --defaults-file=\c:\WINDOWS\my.ini\ Service successfully installed. C:\net start mysql System error 2 has occurred. The system cannot find the file specified. Why is the file not able to be found, I have taken my.ini out of the MySQL installation directory and placed it in the WINDOWS directory. Are there other commands to start a service apart from NET commands,like using mysqladmin? Varuna On Mon, Oct 6, 2008 at 7:07 PM, Armin Schöffmann [EMAIL PROTECTED] wrote: Varuna, obviously it doesn't make much sense, to specify the my.ini location in my.ini itself. The --defaults-file option is used as a direct start-up parameter for mysql-server both, run as service or console-process. It simply tells the server-process where to look for the oneandonly my.ini. Any fullpath given here, overrides the default search-path during server-startup. I assume your server-process has been already started with a --defaults-file -option pointing to a my.ini in the mysql-application-directory, therefor it failed after deleting the file at this location. You may change the direct service-startup options by invoking mysqld-nt with options --remove and --install: With the install option you can specify the complete command-line including additional options which will be used when the server starts as a service. e.g. net stop mysql mysqld-nt --remove mysqld-nt --install MYSQL --defaults-file=\c:\program files(x86)\mysql\my.ini\ net start mysql Regards, Armin. 2008/10/6 Varuna Seneviratna [EMAIL PROTECTED]: I added a line to the [mysqld) group As --defaults-file=C:\WINDOWS\my.ini and then I restarted the service.Everything was fine.Then I took out the my.ini file in the MySQL instalation directory the result was an error message AS Could Not start the MySQL Service on Local Computer Error 1067 The preocess terminated unexpectedly According to the manual MySQL server reads option files in the order Default options are read from the following files in the given order: C:\WINDOWS\my.ini C:\WINDOWS\my.cnf C:\my.ini C:\my.cnf C:\Program Files\MySQL\MySQL Server 5.0\my.ini C:\Program Files\MySQL\MySQL Server 5.0\my.cnf To see the order I ran the command mysqld-nt --verbose --help If the optin files read order is as above why can,t get the service started Varuna -- Aegaeon technologies GmbH phone: +49.941.8107344 fax: +49.941.8107356 Legal disclaimer: http://aegaeon.de/disclaimer/email_all_int.txt -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
Re: Deployment of Database in a DEB package.
I'm sorry that if I can ask a question.What is DEB? On Fri, Oct 3, 2008 at 9:49 PM, US Data Export [EMAIL PROTECTED]wrote: -Original Message- From: Ellison, David [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2008 2:35 AM To: mysql@lists.mysql.com Subject: RE: Deployment of Database in a DEB package. That's true, you would need to consider that risk. Can a DEB package ask for information before deployment? If so you could ask for the username/password and run the mysql command using the provided info. Therefore not risking the problem of having a username/password within the files. Although I am making a big assumption on whether you can grab input and use that in scripts of course :) [JS] Bash, ksh, and other shells have a read command that can be used to take input from the console (or other sources). Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
Re: How could i check the following values in MySQL Server 5.0
Setting is difficult but checking is simple. On Thu, Oct 9, 2008 at 9:26 PM, Amit Sharma [EMAIL PROTECTED] wrote: Hi Sudhir, #show table status command will give you most of what all is required. Have a look at the results post any further query if you have. Regards, Amit Sharma On Thu, Oct 9, 2008 at 6:44 PM, Sudhir Menon [EMAIL PROTECTED] wrote: Hi all, I would like to check or set the following values in MySQL Server . How can that be done ? 1. MySQL Database Free Space for any database. 2. Maximum Database size allowed. 3. Calculate Index Size. 4. Maximum table size 5. Free table space 6. Free Index space 7. Calculate Table size Thanks Regards Sudhir -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
deleted user...lost access to appointment data
It all started when I deleted one of the users, 'michael', from within a database program -- lo and behold 'michael' disappeared from all groups along with the data. 'michael' was an admin user as was another admin user, but the data belonged to 'michael' I recreated this user but could not see the data So I restored the respective mysql database, named pbcs7, from a tar backup (I now understand this is not the best way to backup mysql), but the data remained elusive. The database program - PBCS which is an appointment system - resides in /home/www/public_html and the respective mysql database (MySQL Vers 4.1.20) is in /var/lib/mysql What am I missing please? Steps for restoration of the backup (permissions were found to be preserved): 1. the backed up 'pbcs7' database files were temporarily restored using the tar -zxvf command to: /var/lib/restore/var/lib/mysql/pbcs7/ 2. made copy of files in use (ie the files from which data was missing) to...restore2 directory cp -a /var/lib/mysql/pbcs7/* /var/lib/restore2/ 3. /sbin/service mysqld stop 4. restored pbcs7 database files to the working mysql directory cp -a /var/lib/restore/var/lib/mysql/pbcs7/* /var/lib/mysql/pbcs7/ 5. /sbin/service mysqld start Any help would be great Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql on power6
Hi, anyone have any experience with mysql on power6 for web applications workload?. cheers
Re: Getting more info from show full processlist
One way to do it (maybe the only way for selects) is to use the general log. The Id number, 30399, is the thread id. You can look up the thread id in the general log and see the entire command. But you have to have the general log running. If the command changes data (update, delete, insert) then it'll be in the bin log with the thread id. If you know what time the command was executed, you can use the --start-datetime option of mysqlbinlog. But only the general log keeps selects. On Mon, Oct 6, 2008 at 10:38 AM, MaBa.listas [EMAIL PROTECTED]wrote: Hello, reading the MySQL documentation I've run into the show full processlist\G command. In my case I've got an output similar to this: - mysql show full processlist\G *** 1. row *** Id: 30127 User: root Host: localhost db: NULL Command: Query Time: 0 State: NULL Info: show full processlist *** 2. row *** Id: 30399 User: root Host: localhost db: this would be my DB Command: Sleep Time: 0 State: Info: NULL - What I'd like to know is how to get more info about the query identified with 30399 (in this example). I mean, the exact query, like SELECT pr1, pr2 FROM someDB. Thanks Matias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
Re: deleted user...lost access to appointment data
For some reason when I started reading this, I heard Humphrey Bogart's voice speaking it like the beginning of one of his dark and rainy black white detective movies. ;-) On Mon, Oct 27, 2008 at 10:25 PM, Dr Michael Daly [EMAIL PROTECTED]wrote: It all started when I deleted one of the users, 'michael', from within a database program -- lo and behold 'michael' disappeared from all groups along with the data. 'michael' was an admin user as was another admin user, but the data belonged to 'michael' I recreated this user but could not see the data So I restored the respective mysql database, named pbcs7, from a tar backup (I now understand this is not the best way to backup mysql), but the data remained elusive. The database program - PBCS which is an appointment system - resides in /home/www/public_html and the respective mysql database (MySQL Vers 4.1.20) is in /var/lib/mysql What am I missing please? Steps for restoration of the backup (permissions were found to be preserved): 1. the backed up 'pbcs7' database files were temporarily restored using the tar -zxvf command to: /var/lib/restore/var/lib/mysql/pbcs7/ 2. made copy of files in use (ie the files from which data was missing) to...restore2 directory cp -a /var/lib/mysql/pbcs7/* /var/lib/restore2/ 3. /sbin/service mysqld stop 4. restored pbcs7 database files to the working mysql directory cp -a /var/lib/restore/var/lib/mysql/pbcs7/* /var/lib/mysql/pbcs7/ 5. /sbin/service mysqld start Any help would be great Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
Re: deleted user...lost access to appointment data
I sooo hear that now. That is the funniest thing I have heard this month. On Mon, Oct 27, 2008 at 8:36 PM, Fish Kungfu [EMAIL PROTECTED] wrote: For some reason when I started reading this, I heard Humphrey Bogart's voice speaking it like the beginning of one of his dark and rainy black white detective movies. ;-) On Mon, Oct 27, 2008 at 10:25 PM, Dr Michael Daly [EMAIL PROTECTED] wrote: It all started when I deleted one of the users, 'michael', from within a database program -- lo and behold 'michael' disappeared from all groups along with the data. 'michael' was an admin user as was another admin user, but the data belonged to 'michael' I recreated this user but could not see the data So I restored the respective mysql database, named pbcs7, from a tar backup (I now understand this is not the best way to backup mysql), but the data remained elusive. The database program - PBCS which is an appointment system - resides in /home/www/public_html and the respective mysql database (MySQL Vers 4.1.20) is in /var/lib/mysql What am I missing please? Steps for restoration of the backup (permissions were found to be preserved): 1. the backed up 'pbcs7' database files were temporarily restored using the tar -zxvf command to: /var/lib/restore/var/lib/mysql/pbcs7/ 2. made copy of files in use (ie the files from which data was missing) to...restore2 directory cp -a /var/lib/mysql/pbcs7/* /var/lib/restore2/ 3. /sbin/service mysqld stop 4. restored pbcs7 database files to the working mysql directory cp -a /var/lib/restore/var/lib/mysql/pbcs7/* /var/lib/mysql/pbcs7/ 5. /sbin/service mysqld start Any help would be great Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Rob Wultsch [EMAIL PROTECTED] wultsch (aim)
Re: deleted user...lost access to appointment data
I'm not really sure why that might have happened. I was going to suggest looking on the PCBS Forum for assistance too, but I see you've asked them as well. How did you actually delete the user, 'michael'... through MySQL or through a PCBS admin tool? I am not a guru btw, and encourage anyone to chime in who has ideas. :-) ~~Fish~~ On Mon, Oct 27, 2008 at 11:55 PM, Rob Wultsch [EMAIL PROTECTED] wrote: I sooo hear that now. That is the funniest thing I have heard this month. On Mon, Oct 27, 2008 at 8:36 PM, Fish Kungfu [EMAIL PROTECTED]wrote: For some reason when I started reading this, I heard Humphrey Bogart's voice speaking it like the beginning of one of his dark and rainy black white detective movies. ;-) On Mon, Oct 27, 2008 at 10:25 PM, Dr Michael Daly [EMAIL PROTECTED] wrote: It all started when I deleted one of the users, 'michael', from within a database program -- lo and behold 'michael' disappeared from all groups along with the data. 'michael' was an admin user as was another admin user, but the data belonged to 'michael' I recreated this user but could not see the data So I restored the respective mysql database, named pbcs7, from a tar backup (I now understand this is not the best way to backup mysql), but the data remained elusive. The database program - PBCS which is an appointment system - resides in /home/www/public_html and the respective mysql database (MySQL Vers 4.1.20) is in /var/lib/mysql What am I missing please? Steps for restoration of the backup (permissions were found to be preserved): 1. the backed up 'pbcs7' database files were temporarily restored using the tar -zxvf command to: /var/lib/restore/var/lib/mysql/pbcs7/ 2. made copy of files in use (ie the files from which data was missing) to...restore2 directory cp -a /var/lib/mysql/pbcs7/* /var/lib/restore2/ 3. /sbin/service mysqld stop 4. restored pbcs7 database files to the working mysql directory cp -a /var/lib/restore/var/lib/mysql/pbcs7/* /var/lib/mysql/pbcs7/ 5. /sbin/service mysqld start Any help would be great Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Rob Wultsch [EMAIL PROTECTED] wultsch (aim)
