The following information may have errors; It is not permissible to be read by anyone who has ever met a lawyer. Use is confined to Engineers with more than 370 course hours of electronic engineering for theoretical studies. All content entered becomes and is (C)2007 Transtronics, Inc. the property of Transtronics, Inc. Rest assured that your contributions won't be sold and will be publicly available.
ph +1(785) 841 3089 Email inform@xtronics

From Transwiki

[edit] mysql 5.0 on Debian

[edit] If you are using binary logs

There has been a change (march of 07?? - with etch?) you need to add to /etc/mysql/my.cnf

expire_logs_days = 15

Some time in days that would be more than your back up time would make sense.

[edit] Editing MySQL tables as CSV

[edit] Using gnumeric to edit Mysql tables

The mySQL Query Browser allows one to double click on a table to return the listing.

Next , select File/Export result set/as CSV.

The named file can be edited in gnumeric.

Saving as CSV causes only the displayed values to get exported - no formulas or functions are stored - if you need theses save as a spreadsheet file first..

[edit] Loading the updated file back to MySQL

Make a copy of the old table with a SQL query:

 create table table_name_new Like table_name;
 

Now delete the old data:

 Delete from `table_name_new`
 

Now load the new table with the new data

 LOAD DATA LOCAL INFILE '/path/newdata.csv'
 INTO TABLE table_name_new
 FIELDS TERMINATED BY ','
 LINES TERMINATED BY '\n'
 (field1, filed2, field3);
 

The last line can be left off if the data is in order and the line before as well if it is on a Linux system.

[edit] Moving from a test server to live server

On the test server:

 mysqldump  -ppassword --opt --single-transaction db_name --tables table_name1 table_name2 > filename.sql
 

Move filename.sql over to the live server and -

 mysql -u root -ppassword db_name < filename.sql