[EMAIL PROTECTED] locations
Greetings, I've got a retail operation with mysql 5.0.22 on linux pc's across the country, and i need some input on setting up a backup strategy, preferrably without purchasing a package. We're currently using MyISAM, with the databases being dumped to a filesystem on a separate drive, in case the main drive goes down. However we will need to implement some kind of transactional engine in the near future, and we'd prefer not to take down the database to take a backup. Any thoughts ? Thanks Pierre - Looking for last minute shopping deals? Find them fast with Yahoo! Search.
Re: Can I select from remote tables in mysql 5.0.18-standard-log?
Thanks all, this looks exactly like what i'm looking for. However, when I create the federated table, it says it was successful but creates the table as Myisam. CREATE TABLE `petestdb.backup_pp_line_code` ( `catalog_id` int(10) unsigned NOT NULL, `line_code` char(3) NOT NULL, `product_typ_id` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`catalog_id`,`product_typ_id`), KEY `line_code_Index_2` (`line_code`) ) ENGINE=federated DEFAULT CHARSET=latin1 connection='mysql://[EMAIL PROTECTED]:3306/database2/backup_pp_line_code'; Show create table gives me : backup_pp_line_code | CREATE TABLE `backup_pp_line_code` ( `catalog_id` int(10) unsigned NOT NULL, `line_code` char(3) NOT NULL, `product_typ_id` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`catalog_id`,`product_typ_id`), KEY `line_code_Index_2` (`line_code`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CONNECTION='mysql://[EMAIL PROTECTED]:3306/database2/backup_pp_line_code' | When I query the federated table, it says 0 rows although the target has over 12000 rows. Could the mysql-max distribution be a factor ? How do I verify if this is what i'm running ? Paul DuBois [EMAIL PROTECTED] wrote: At 14:38 -0700 4/27/06, P. Evans wrote: Hello Listers, Is it possible to run a query on one mysql server to another database on a different server ? eg creating an alias in database A on server A to table B on database B on server B ? Like a federated nickname on db2 udb or synonym on informix ? You can use FEDERATED to access tables on other MySQL servers. http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com - How low will we go? Check out Yahoo! Messengers low PC-to-Phone call rates.
Can I select from remote tables in mysql 5.0.18-standard-log?
Hello Listers, Is it possible to run a query on one mysql server to another database on a different server ? eg creating an alias in database A on server A to table B on database B on server B ? Like a federated nickname on db2 udb or synonym on informix ? Thanks Pierre - Yahoo! Mail goes everywhere you do. Get it on your phone.
mysqlimport debug options
Hello Listers, Can anyone explain what are valid values for the 'debug options' on a mysqlimport ? The manuals just say : --debug[=debug_options], -# [debug_options] Write a debugging log. The debug_options string often is 'd:t:o,file_name'. What is d: ? t: ? o (ok,thats relatively easy but just to be sure...) ? This is mysql Ver 14.12 Distrib 5.0.15, for sun-solaris2.9 (sparc) using readline 5.0 Thanks Pierre - Yahoo! Shopping Find Great Deals on Holiday Gifts at Yahoo! Shopping
Re: 1266 creating innodb tables
Much thanks, that did the trick. Pierre Jasper Bryant-Greene [EMAIL PROTECTED] wrote: P. Evans wrote: skip-innodb is commented out,thats why its not in the options I sent previously. The logs are showing something peculiar - InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes InnoDB: than specified in the .cnf file 0 268435456 bytes! ls shows : drwxr-x--- 2 myznet myznet 2048 Oct 27 10:52 mysql -rw-rw 1 myznet myznet 5242880 Oct 31 00:32 ib_logfile1 -rw-rw 1 myznet myznet 20688404480 Oct 31 16:27 ibdata1 -rw-rw 1 myznet myznet 5242880 Oct 31 16:27 ib_logfile0 but in /etc/my.cnf, innodb_log_file_size = 256M What gives ? How can I get the logfiles in synch ? That's your problem. Back up and remove the old ib_logfile* files and restart MySQL to recreate them. Either you have changed the log file size in my.cnf or you've upgraded MySQL and the default has changed. Jasper - Yahoo! FareChase - Search multiple travel sites in one click.
Re: 1266 creating innodb tables
skip-innodb is commented out,thats why its not in the options I sent previously. The logs are showing something peculiar - InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes InnoDB: than specified in the .cnf file 0 268435456 bytes! ls shows : drwxr-x--- 2 myznet myznet 2048 Oct 27 10:52 mysql -rw-rw 1 myznet myznet 5242880 Oct 31 00:32 ib_logfile1 -rw-rw 1 myznet myznet 20688404480 Oct 31 16:27 ibdata1 -rw-rw 1 myznet myznet 5242880 Oct 31 16:27 ib_logfile0 but in /etc/my.cnf, innodb_log_file_size = 256M What gives ? How can I get the logfiles in synch ? Pierre Jasper Bryant-Greene [EMAIL PROTECTED] wrote: P. Evans wrote: Shawn, as far as I can tell, no. Here's all my innodb options set in my.cnf : Well, it's easy to check: grep skip-innodb my.cnf Is there anything interesting in the logs, maybe on MySQL startup? Jasper - Yahoo! FareChase - Search multiple travel sites in one click.
Re: 1266 creating innodb tables
Here's an example : mysql create table petest (col1 integer,col2 char(5)) engine=innodb; Query OK, 0 rows affected, 1 warning (0.07 sec) mysql show warnings - ; +-+--++ | Level | Code | Message| +-+--++ | Warning | 1266 | Using storage engine MyISAM for table 'petest' | +-+--++ 1 row in set (0.00 sec) Jasper Bryant-Greene [EMAIL PROTECTED] wrote: P. Evans wrote: Whenever I try to create a table using innodb, i get a 1266 warning that the table has been created with myisam instead. I receive the error both at the mysql command line and using the mysql query browser. Can you please show us the CREATE TABLE command that you are using? - Yahoo! FareChase - Search multiple travel sites in one click.
Re: 1266 creating innodb tables
Shawn, as far as I can tell, no. Here's all my innodb options set in my.cnf : innodb_additional_mem_pool_size = 16M innodb_buffer_pool_size = 4G innodb_data_file_path = ibdata1:10M:autoextend innodb_file_io_threads = 4 innodb_thread_concurrency = 16 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size = 8M innodb_log_file_size = 256M innodb_log_files_in_group = 3 innodb_max_dirty_pages_pct = 90 innodb_lock_wait_timeout = 120 Anywhere else I can check for that ? Pierre [EMAIL PROTECTED] wrote: Is your server configured with skip-innodb ? It's an option that turns off support to that engine forcing it to elect a different method of storage. Shawn Green Database Administrator Unimin Corporation - Spruce Pine P. Evans [EMAIL PROTECTED] wrote on 11/10/2005 10:10:44 AM: Here's an example : mysql create table petest (col1 integer,col2 char(5)) engine=innodb; Query OK, 0 rows affected, 1 warning (0.07 sec) mysql show warnings - ; +-+--++ | Level | Code | Message| +-+--++ | Warning | 1266 | Using storage engine MyISAM for table 'petest' | +-+--++ 1 row in set (0.00 sec) Jasper Bryant-Greene [EMAIL PROTECTED] wrote: P. Evans wrote: Whenever I try to create a table using innodb, i get a 1266 warning that the table has been created with myisam instead. I receive the error both at the mysql command line and using the mysql query browser. Can you please show us the CREATE TABLE command that you are using? - Yahoo! FareChase - Search multiple travel sites in one click. - Yahoo! FareChase - Search multiple travel sites in one click.
1266 creating innodb tables
Whenever I try to create a table using innodb, i get a 1266 warning that the table has been created with myisam instead. I receive the error both at the mysql command line and using the mysql query browser. I've also tried alterring the table to change the engine , which says it completes successfully but still has the 1266 warning. eg alter table pp_related_product_type engine=innodb; Query OK, 0 rows affected, 1 warning (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql show warnings; +-+--+-+ | Level | Code | Message | +-+--+-+ | Warning | 1266 | Using storage engine MyISAM for table 'pp_related_product_type' | +-+--+-+ 1 row in set (0.00 sec) I'm using mysql Ver 14.12 Distrib 5.0.15, for sun-solaris2.9 (sparc) using readline 5.0. Has anyone come across this before ? Any suggestions ? Thanks Pierre - Yahoo! FareChase - Search multiple travel sites in one click.