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
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
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
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
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
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
|
+-+--++
| 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
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
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
