Hello Ben, all!
Ben Burford wrote:
Hello,
This is my first message, I'm an absolute beginner in Mysql. I did a defaul
t installation of version 3.23.58 on RH Linux AS3.0. [[...]]
I will not comment on the backup issue, that has been done already.
However, I _strongly_ urge you to upgrade
mysqldump --verbose --add_drop-table --all-databases > backup_06082006.sql
or
mysql --add_drop-table < backup_06082006.sql
or maybe
mysql < --add_drop-table backup_06082006.sql
mysqldump --opt...
This will add DROP TABLE .. IF EXISTS to a dump.
--
MySQL General Mailing List
For list
On 6/9/06, Ben Burford <[EMAIL PROTECTED]> wrote:
Hello,
This is my first message, I'm an absolute beginner in Mysql. I did a defaul
t installation of version 3.23.58 on RH Linux AS3.0. I want to be a able to
do a backup and a restore.
The user's manual says:
5.9.2.1 Backup Policy
The follow
Hi Eugene,
Good to hear from you. Should I use this on the creation or the restore? A
s in:
mysqldump --verbose --add_drop-table --all-databases > backup_06082006.sql
or
mysql --add_drop-table < backup_06082006.sql
or maybe
mysql < --add_drop-table backup_06082006.sql
or maybe something
Ben Burford wrote:
Hello,
Do I need to delete the table 'Indian'??
Try --add_drop-table option
man mysqldump
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I prefder to use a FREE GUI like SQLyog found at
http://www.webyog.com
Karam
--- Gary Richardson <[EMAIL PROTECTED]> wrote:
> try mysqldump -keq SDN > SDN.sql
>
> Then you can import it on another instance using
> mysql -u root
> new_instance < SDN.sql
>
> On 5/5/05, zlf <[EMAIL PROTECTED]> wro
try mysqldump -keq SDN > SDN.sql
Then you can import it on another instance using mysql -u root
new_instance < SDN.sql
On 5/5/05, zlf <[EMAIL PROTECTED]> wrote:
> Hi all,
> I have installed a MySQL5.0 instance on Windows. And then created a
> database( named 'SDN' ). Now I want to move this