RE: MySQL Poll
MysqlFront is thé best tool for me. http://anse.de/mysqlfront/download.php Works on remote databases to, nice and smooth interface, exporting tables in various formats, export/import from one active db to another ... B. -Original Message- From: Correale, Ernest [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 05:19 To: '[EMAIL PROTECTED]' Subject: RE: MySQL Poll I have been using MySQLAdmin for some time. It has a few oddities about refreshing local data but other than that it's very good. The other tool that I just started working with is MyCC. So far I like that one alot as well. Both are worth looking at. MySQLAdmin is not free but thats of little concern to me since I feel purchasing a product is a good way to show support for the MySQL project. -Original Message- From: Marvin Cummings To: [EMAIL PROTECTED] Sent: 7/14/02 10:17 PM Subject: MySQL Poll If it's ok with the site admin, I'd like to post a poll to see what utilities are being used to administer mysql on w2k. I was dreading having to actually use a command prompt to manage and administer mysql until I found this mysql-front tool, which seems to handle all of those responsibilities. So I guess my question is what tools are being used? Again this is on a w2k server running apache php4. - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - 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
RE: Implementing commit,transaction in isam table type
Seems fairly impossible to me to really emulate transactions on a non-transactional db. Even if you develop a system where you : a. collect all queries untill the end and then perform them in 1 block b. keep your own logs of the queries and be able to roll them back in case of error even then it will not be a real transaction, because for example : - a server-crash whilest doing the 1-block-query will corrupt the database - same for the roll back you have written - you don't have isolation levels, so queries will read wrong data - ... Switch to InnoDB is my advice :) B. -Original Message- From: Pierre Baridon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 08:11 To: smart chandar; [EMAIL PROTECTED] Subject: Re: Implementing commit,transaction in isam table type why not using innodb tables ? smart chandar wrote: I am using Mysql Db that contains Isam table types,I am developing a project that is using interrelated tables,unfortunatily isam table type doesn't support the commit and transaction,but i should implement that,can anyone give a logic for that thanks in advance with regards chandar __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com - 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 - 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 - 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
RE: SHOW TABLE STATUS InnoDB Tables
From the manual : Note that the statistics SHOW gives about InnoDB tables are only approximate: they are used in SQL optimization. Table and index reserved sizes in bytes are accurate, though. CB. -Original Message- From: Crercio O. Silva [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 01:51 To: [EMAIL PROTECTED] Subject: BUG: SHOW TABLE STATUS InnoDB Tables Hi, I have just noticed that SHOW TABLE STATUS is returning different number of rows each time you execute the query. This seams to affect only InnoDB Tables (Although I have tested only with ISAM/MyISAM/InnoDB Tables). I'm using MySQL 3.23.49Max on WIN2K. How to repeat the problem: Execute the statement SHOW TABLE STATUS many times. In some times (not all) it will return different number of rows for the same table. Have anyone else experienced this with other versions? PS: SELECT COUNT(*) FROM table is working just fine, but on InnoDB tables with large number of rows (my tables have -+ 30 records each) it take a few seconds to get the results. This is not a big issue for me, but I'd like to confirm that. Thanks, []'s Crercio O. Silva - 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 - 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
RE: innodb is disabled, how can i make it yes?
Are you sure that you are starting mysqld-max-nt.exe for the server ? If so, try mysqld-max-nt --print-defaults to see what parameters are set, maybe that will give you a clue ... CB. -Original Message- From: Hytham Shehab [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 00:19 To: Paul DuBois Cc: [EMAIL PROTECTED] Subject: Re: innodb is disabled, how can i make it yes? hi Paul: Make sure it's not being started with --skip-innodb. i am sure that the --skip-innodb is not in any of my configuration files. sql -- Hytham Shehab --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 20/06/2002 - 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 - 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
RE: starting MySQL automatically
You can use the winmysqladmin tool located in the bin directory to install it as a service. (I'm not sure wether this also works on a '98SE machine) CB -Original Message- From: Gerhard H. W. May [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 15:00 To: [EMAIL PROTECTED] Subject: starting MySQL automatically Hello, I am running MySQL 3.23.51 under Windows 98SE. Everything I need to do so far seems to work but I would like to arrange it so that the server starts up automatically when I switch on the machine. Maybe I am too stupid but I don't understand the section (2.4.3) in the reference manual on 'Starting and stopping MySQL automatically', but then again this section might not be relevant to Windows users anyway? If anyone has suggestions what I should do, I would welcome them. Thanks in advance. Gerhard ~~ Dr. Gerhard H. W. May Institute of Biomedical and Life Sciences Division of Biochemistry and Molecular Biology Davidson Building, Rm 327 University of Glasgow Glasgow G12 8QQ Tel. +44-141-330 2749 Fax+44-141-330 4620 e-mail [EMAIL PROTECTED] http://www.gla.ac.uk/ibls/BMB/gmay/ - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - 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
RE: PERROR on Windows
Yes there is: perror.exe located in c:\yourmysqldir\bin\ :) -Original Message- From: Christopher A. Libby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 15:16 To: [EMAIL PROTECTED] Subject: PERROR on Windows Is there a command like perror for the Windows version of MySQL? I can't seem to find anything to list error code descriptions in either MySQL 3 or 4. TIA - Chris - 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 - 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
RE: high level: enabling transactions in mysql-max with WebLogic TX datasource?
Hi again, I really think you should walk yourself through the InnoDB user manual at http://www.innodb.com/ibman.html There's a lot of usefull and explanory information in there. For your question: ib_arch and ib_logfileX are the logs that InnoDB uses to track committed transactions and perform recovery in case of an DataBase crash. Having all these files in the same directory is kinde messy, maybe you wanne use a config file like the one at the bottom of my reply. The kind of logging you need is the one indicated by the log parameter in the config file. The binary logging that we use is only usefull if you want to be able to do recovery for certain time spans. Also you can start your server manually at the command prompt with c:\yourmysqldir\bin\mysqld-max-nt --console This way you will be able to see any (error) messages directly in the console ... Have fun, I know I did ;) CB. = # The MySQL server [mysqld] # Activate binary logging for MySQL log-bin=C:/mysql/binlogs/localhost-bin # Only binary log queries for table TW binlog-do-db=tw # Prevent those stupid lower case table names when importing/exporting dumps set-variable = lower_case_table_names=0 # InnoDB logging file # log=log.txt # Default table type for new tables default-table-type=InnoDB # BDB home - mysqld-max will not start without this parameter # and the directory must exist bdb-home=../bdbhome # Data home dir of your InnoDB tables innodb_data_home_dir = c:\mysql\ibdata #Data files must be able to #hold your data and indexes innodb_data_file_path = ibdata1:500M #Set buffer pool size to 50 - 80 % #of your computer's memory set-variable = innodb_buffer_pool_size=200M set-variable = innodb_additional_mem_pool_size=15M # Logging innodb_log_group_home_dir = c:\mysql\iblogs #.._log_arch_dir must be the same #as .._log_group_home_dir innodb_log_arch_dir = c:\mysql\iblogs innodb_log_archive=0 set-variable = innodb_log_files_in_group=3 #Set the log file size to about #15 % of the buffer pool size set-variable = innodb_log_file_size=25M set-variable = innodb_log_buffer_size=10M #Set ..flush_log_at_trx_commit to #0 if you can afford losing #a few last transactions innodb_flush_log_at_trx_commit=1 set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 == -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 23:14 To: [EMAIL PROTECTED] Subject: Re: high level: enabling transactions in mysql-max with WebLogic TX datasource? Bert == Bert VdB [EMAIL PROTECTED] writes: Bert Hi, Bert all you have to do use a transaction enabled data-source and use the Bert Mm-MysqlDriver Bert for your JDBC connections. (http://mmmysql.sourceforge.net/) Bert Best is to read the InnoDB documentation carefully (http://www.innodb.com), Bert as you cannot choose from a wide Bert variety of transaction-levels ... in my experience, most of the detailed Bert transaction-handling Bert can only be done at mysql-query level. Bert To test wether your datasource supports the transactions, do a test and look Bert at the InnoDB-logfiles, it should Bert indicate some thing like SET AUTOCOMMIT=0 and COMMIT. Ok, I determined that innodb wasn't being initialized because I didn't have innodb_data_file_path set in my.ini. I added the following line to my.ini in mysqladmin: innodb_data_file_path = ibdata1:30M:autoextend After I restarted the service and created some tables (not adding any rows yet), I noticed the following files in the data subdirectory: --- total 41004 drwxr-xr-x2 dmkarr None 8192 Jul 1 15:01 mysql/ -rw-r--r--1 dmkarr None 2461 Jul 1 14:59 mysql.err -rw-r--r--1 dmkarr None 5242880 Jul 1 14:59 ib_logfile0 -rw-r--r--1 dmkarr None 31457280 Jul 1 14:59 ibdata1 drwxr-xr-x4 dmkarr None 4096 Jul 1 14:59 ./ -rw-r--r--1 dmkarr None25088 Jul 1 14:59 ib_arch_log_00 -rw-r--r--1 dmkarr None 5242880 Jul 1 14:59 ib_logfile1 drwxr-xr-x 11 dmkarr None 4096 Jun 29 11:30 ../ drwxr-xr-x2 dmkarr None0 Jun 29 11:07 test/ --- However, I don't know how to check the log files for those strings, as they appear to be binary. A simple grep didn't find anything. Is there a special viewer for mysql log files
RE: high level: enabling transactions in mysql-max with WebLogic TX datasource?
Hi, all you have to do use a transaction enabled data-source and use the Mm-MysqlDriver for your JDBC connections. (http://mmmysql.sourceforge.net/) Best is to read the InnoDB documentation carefully (http://www.innodb.com), as you cannot choose from a wide variety of transaction-levels ... in my experience, most of the detailed transaction-handling can only be done at mysql-query level. To test wether your datasource supports the transactions, do a test and look at the InnoDB-logfiles, it should indicate some thing like SET AUTOCOMMIT=0 and COMMIT. Greetz, CB. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 30, 2002 22:33 To: [EMAIL PROTECTED] Subject: high level: enabling transactions in mysql-max with WebLogic TX datasource? One thing that I find a little confusing is the notion of transactional behavior in mySQL. I read that it's possible to enable transactions in mySQL-max, however, it's never really been clear to me exactly what I'm supposed to do, or whether I have to do anything. If I'm using a transactional datasource in WebLogic, on top of mySQL, I need to make sure mySQL supports that transactional behavior. Is there a section of the mySQL documentation, or some other documentation, which explains these issues clearly? -- === David M. Karr ; Java/J2EE/XML/Unix/C++ [EMAIL PROTECTED] - 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 - 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
FW: Display Records in Multiple Pages
Oops, forgot to send it to the list: Use an index and offset in your queries. You need 25 queries per page(=the offset), each page starting display from a different record (=the index) This would give something like this for page 1: $result = mysql_query(SELECT * FROM your_table WHERE table_field = 'blahblah' ORDER BY table_field ASC LIMIT 0,25); == this will result in records 1 to 24 For page 2, in one way or another, you just increase the index by 25, resulting in $result = mysql_query(SELECT * FROM your_table WHERE table_field = 'blahblah' ORDER BY table_field ASC LIMIT 25,25); For page 3 : $result = mysql_query(SELECT * FROM your_table WHERE table_field = 'blahblah' ORDER BY table_field ASC LIMIT 50,25); Of course, you define the index as a php-variable and automatically increase it every next page. Hope it helps, CB -Original Message- From: Aqua [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 07:55 To: [EMAIL PROTECTED] Subject: Display Records in Multiple Pages I have 100 records in mySQL database and I need to display them in my web page using php and html. How to display them in multiple pages? Each page must contain 25 records. Does anyone know how to do it other than create 4 pages and manually list the records there? or maybe point me some reference please. Your help will be much appreciated. Thanks! Aqua - 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 - 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
RE: default table type
Add this to your my.cnf file : # The MySQL server [mysqld] # Default table type for new tables default-table-type=InnoDB CB. -Original Message- From: Pierre Baridon [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 12:09 To: [EMAIL PROTECTED] Subject: default table type how can i change the default table type ? (innodb instead of myisam) thanks, Pierre -- sql,query - 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 - 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
RE: How to recover if .frm file get lost/corrupted
I think u just have to create exactly the same table in another database, and then copy the .frm file to the one where you lost the original one. CB -Original Message- From: Jonathan Stockley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 00:20 To: [EMAIL PROTECTED] Subject: How to recover if .frm file get lost/corrupted Hi, I see from the docs that MySQL tables created using TYPE=InnoDB still require a seperate .frm file. What are the ramifications if this get corrupt or other wise lost. Does one have to restore from backup or is there as online recovery tool? Cheers, Jo - 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 - 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
RE: innodb bug
Hi, I'm sort of glad we're not the only one having this problem. Yesterday we had kind of the same error message on an Solaris 8 machine with 512Mb of ram. Our buffer_pool_size was set to 250Mb, because the other 250Mb is used by the orion-web-server. Today I will perform crash-tests on another machine and try to find out the problem. Fyi, our error log: = /opt/nusphere/mysql-max-3.23.49-sun-solaris2.8-sparc/bin/mysqld: ready for connections mysqld got signal 10; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=8388600 record_buffer=131072 sort_buffer=2097144 max_used_connections=16 max_connections=100 threads_connected=3 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 225791 K bytes of memory Hope that's ok, if not, decrease some variables in the equation 020625 15:39:58 mysqld restarted 020625 15:40:34 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 272046313 InnoDB: Fatal error: cannot allocate 2310548 bytes of InnoDB: memory with malloc! Total allocated memory InnoDB: by InnoDB 334012166 bytes. Operating system errno: 11 InnoDB: Cannot continue operation! InnoDB: Check if you should increase the swap file or InnoDB: ulimits of your operating system. InnoDB: On FreeBSD check you have compiled the OS with InnoDB: a big enough maximum process size. 020625 15:40:37 mysqld ended -Original Message- From: Shakeel Sorathia [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 25, 2002 21:01 To: [EMAIL PROTECTED] Subject: innodb bug I've been having a problem with innodb lately. We just upgraded one of our machine to have 4 GB of ram in it. However, whenever I make the innodb_buffer_pool_size greater then 2048M It crashes with the following in the error log. It's 3.23.51 running on a Solaris 8 Ultrasparc II machine with 4 GB ram. Is the limit 2gb of ram, or is there something that I'm doing wrong? Thanks for the help! --shak 020625 12:57:14 mysqld started InnoDB: Assertion failure in thread 1 in file ../include/buf0buf.ic line 214 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=8388600 record_buffer=131072 sort_buffer=1048568 max_used_connections=0 max_connections=1024 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 1187831 K bytes of memory Hope that's ok, if not, decrease some variables in the equation 020625 12:57:54 mysqld ended -- Shakeel Sorathia Systems Administrator (213) 739-5348 - 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 - 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
RE: installing 2 servers on the same Win 2K machine
Hi, I have 2 version installed on my win2k machinge (.49 , .50 and .51) As long as you install in different directories , take care of config files and don't try to start 2 server simultaniously, I don't see why this should give problems. (At least, I haven't got any problems ;) ) CB. -Original Message- From: Okan CIMEN [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 08:09 To: [EMAIL PROTECTED] Subject: installing 2 servers on the same Win 2K machine Hello, I am planning to install 2 mysql servers on the same box whish runs Win2K. Has anyone experianced this before? Regards Okan - 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 - 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
RE: Re-do logging feature with InnoDB: is it possible ?
Hello everybody, I have a small question regarding to the Mysql-InnoDB-tables : Is it possible to use an Oracle-like 're-do logging' feature with InnoDB ? This means more or less taking regular consistent backups of your database, and then in case of corruption, you restore the latest consistent database-backup and tell the server to re-apply the logs for a certain time-span. I haven't found any information on this feature for InnoDB, but I still would like to consult you guys before passing a definitive NO CAN DO to the managament of the project here :) Tnx for you input and time, CB. - 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
FW: Binary data mysqldump and restore.
Just for those people who have the same problem: -Original Message- From: Mark Williams (MWP) [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 11:13 To: Bert VdB Subject: Re: Binary data mysqldump and restore. That did it thanks! MWP Hi, Have you tried making a dump with the --opt option ? CB. -Original Message- From: Mark Williams (MWP) [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 09:57 To: [EMAIL PROTECTED] Subject: Binary data mysqldump and restore. This message uses a character set that is not supported by the Internet Service. To view the original message content, open the attached message. If the text doesn't display correctly, save the attachment to disk, and then open it using a viewer that can display the original character set. - 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