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 cas
fy 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 se
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 relative
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_logfil
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 a
x27;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
Code | Message|
+-+--++
| Warning | 1266 | Using storage engine MyISAM for table 'petest' |
+-+--++
1 row in set (0.00 sec)
Jasper Bryant-Greene <[EMAIL PR
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
complet
