Hi
I've just reinstalled my system and used the oportunity to get the latest
MySQL, so I got 6.0.4 version and installed it.
The problem is that want to restore some tables but 'RESTORE TABLE' nor
'RESTORE DATABASE' (as specified in the manual online) are not available,
:20 AM
Subject: Re: backup table/restore table question
> I use mysqldump which generates sql for you and it
> works like a charm. Eg,
>
> mysqldump --user=root databasename.table > output.sql
>
> The output.sql file then has SQL statements to
> generate and exact copy.
>
&g
At 20:23 -0400 4/12/04, Andy B wrote:
hi...
i have a server where there are 5 tables inside a database. i was wondering
if i did the following command from inside a script:
backup table dbname.tablename to /home/users/my_dir/
then with a different script gzip/tar them, after gzipped ftp them to my
hi...
i have a server where there are 5 tables inside a database. i was wondering
if i did the following command from inside a script:
backup table dbname.tablename to /home/users/my_dir/
then with a different script gzip/tar them, after gzipped ftp them to my
test server into say c:/db_backup/db_
Hi!
Has anybody run into this?
We backed up a MyISAM Table using "BACKUP TABLE" while other
processes created a larger load of INSERTs, DELETEs, UPDATEs,
and SELECTs against this table.
BACKUP TABLE returned with "OK".
We generated several backups of the same table at different times.
Upon restori
"Jian Sun" <[EMAIL PROTECTED]> wrote:
>
>Does anybody know how to drop table option? I added a table option "alter table
> abc order by col1 desc". Now I want to remove this option, How can I do?
ORDER isn't a table option, it's a single time action.
--
For technical support contracts,
Hi there,
Does anybody know how to drop table option? I added a table option "alter table
abc order by col1 desc". Now I want to remove this option, How can I do?
Thanks
e with another name. RESTORE TABLE table_name is
looking for a files table_name.* in your dir, can't find them and as a
result gives you error. So, you can restore table only with the same name.
If you want to rename table use RENAME TABLE statement.
RS> Ritu
--
For technical su
12:12:15 PM, you wrote:
>
> rs> I used BACKUP TABLE command to take the backup of a
> rs> table...but when i say
> rs> RESTORE TABLE, i get the following ::
>
> rs> mysql> restore table rs from '/tmp';
> rs> +---+-+--+-
ritu,
Friday, May 10, 2002, 12:12:15 PM, you wrote:
rs> I used BACKUP TABLE command to take the backup of a
rs> table...but when i say
rs> RESTORE TABLE, i get the following ::
rs> mysql> restore table rs from '/tmp';
rs> +---+-+--+---
i'm using Mysql ver. 3.23.49...
Ritu
On Fri, 10 May 2002, Jeremy Zawodny wrote:
> On Fri, May 10, 2002 at 10:12:15AM +0100, ritu singla wrote:
> > Hi!!
> >
> > I used BACKUP TABLE command to take the backup of a
> > table...but when i say
> &
On Fri, May 10, 2002 at 10:12:15AM +0100, ritu singla wrote:
> Hi!!
>
> I used BACKUP TABLE command to take the backup of a
> table...but when i say
> RESTORE TABLE, i get the following ::
>
>
> mysql>
Hi!!
I used BACKUP TABLE command to take the backup of a
table...but when i say
RESTORE TABLE, i get the following ::
mysql> restore table rs from '/tmp';
+---+-+--+--+
| Table | Op | Msg_ty
Hello;-)
I recently lost the entire mysql Database when my harddrive crashed,
fortunately, I thought, I had backed up all of the tables via
"Backup tables Address,Travel, etc to '/apps/back/mysql/database';"
The command worked, (once I created the directory and gave read/write power
to mysql
Thank you very much for the reply. I'll give it a try.
Richard
Jeremy Zawodny wrote:
>
> On Mon, Jun 04, 2001 at 04:50:03PM -0700, Richard Reina wrote:
>
> > I accidently overote a table in my database. I need to restore an
> > individual table from a backup that I made on tape drive with dum
On Mon, Jun 04, 2001 at 04:50:03PM -0700, Richard Reina wrote:
> I accidently overote a table in my database. I need to restore an
> individual table from a backup that I made on tape drive with dump.
> How can I restore just the individual table with restore -i.
Restore the .{frm,MYI,MYD} files
I accidently overote a table in my database. I need to restore an
individual table from a backup that I made on tape
drive with dump. How can I restore just the individual table with
restore -i.
Richard
-
Before posting, please
and linux computers, can't get it to restore on any of
the files.
mysql query = RESTORE TABLE emails From 'c:\unzipped\Bairns' \G
Thank you in advance
Simon
-
Before posting, please check:
http://www.mysql.com
18 matches
Mail list logo
