MySQL Forums
Forum List  »  Backup

Backup using tar.gz
Posted by: Luis Torres
Date: February 16, 2005 10:23AM

Hi.

I´m doing some kind of a experiment....I´m using MySQL:
MySQL-devel-4.0.20-0
MySQL-embedded-4.0.20-0
MySQL-server-4.0.20-0
MySQL-client-4.0.20-0
MySQL-bench-4.0.20-0
MySQL-shared-4.0.20-0
MySQL-Max-4.0.20-0
MySQL-shared-compat-4.0.18-0
I stopped mysqld service, and I did a tar.gz of the file /etc/my.cnf, my.cnf contains this:

[mysqld]
# Set data file path and sizes
innodb_data_home_dir =
innodb_data_file_path = /app2/mysqldb/ibdata1:4G;/app2/mysqldb/ibdata2:4G;/app2/mysqldb/ibdata3:4G;/app2/mysqldb/ibdata4:4G;/app2/mysqldb/ibdata5:4G;/app2/mysqldb/ibdata6:4G;/app2/mysqldb/ibdata7:4G;/app2/mysqldb/ibdata8:4G;/app2/mysqldb/ibdata9:4G;/app2/mysqldb/ibdata10:4G;/app2/mysqldb/ibdata11:4G;/app2/mysqldb/ibdata12:4G;/app2/mysqldb/ibdata13:4G;/app2/mysqldb/ibdata14:4G;/app2/mysqldb/ibdata15:4G;/app/mysqldb/ibdata16:4G;/app/mysqldb/ibdata17:4G;/app/mysqldb/ibdata18:4G;/app/mysqldb/ibdata19:4G;/app/mysqldb/ibdata20:4G;/app/mysqldb/ibdata21:632291328;/app3/mysqldb/ibdata22:4G;/app3/mysqldb/ibdata23:4G;/app3/mysqldb/ibdata24:4G;/app3/mysqldb/ibdata25:4G;/app3/mysqldb/ibdata26:4G;/app3/mysqldb/ibdata27:4G
# Log files
innodb_log_arch_dir = /app2/mysqldb
innodb_log_group_home_dir = /app2/mysqldb
#
# Set buffer pool size to 50-80% of your computer's memory
set-variable = innodb_buffer_pool_size=600M
set-variable = innodb_additional_mem_pool_size=10M
#
# Set the log file size to about 25% of the buffer pool size
set-variable = innodb_log_file_size=125M
set-variable = innodb_log_buffer_size=8M
#
innodb_flush_log_at_trx_commit=1


I also did a tar.gz of all ibdata (ibdata1, ibdata2....ibdata27)...then I install another computer with linux, and mysql 5.0...I uncompressed the files (I created the same directories /app/mysqldb and /app2/mysqldb), I replaced the /etc/my.cnf file with the my.cnf.tar.gz file.....but when i tried to start the mysqld service I doesn´t come up.....any clues?

Options: ReplyQuote


Subject
Views
Written By
Posted
Backup using tar.gz
6896
February 16, 2005 10:23AM
3297
February 18, 2005 03:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.