Versions Compared

Old Version 6

changes.mady.by.user Anhei Shu

Saved on

compared with

New Version 7

changes.mady.by.user Anhei Shu

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Create the table properly (with index)
  2. Flush table
    No Format
    $ mysqladmin flush-tables -u binga_db_user -p
  3. Removes all use of indexes for the table
    No Format
    $ sudo myisamchk --keys-used=0 -rq /var/lib/mysql/dbName/tblName
  4. LOAD DATA LOCAL INFILE. Adjust the parameters corresponding to your csv file.
    No Format
    $ mysql -u your_user_name -p
mysql> use your_db_name;
mysql> LOAD DATA LOCAL INFILE 'your_data_file.csv' INTO TABLE `your_tbl_name` FIELDS TERMINATED BY ';' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' IGNORE 1 LINES;
  5. Re-create the indexes
    No Format
    $ sudo myisamchk --key_buffer_size=1024M --sort_buffer_size=1024M -rq /var/lib/mysql/dbName/tblName
  6. Flush table
    No Format
    $ mysqladmin flush-tables -u bing -p

...