Category: Scripting
Linux
Read More
Import csv data to mysql
This is a short note about how to import comma separated data, CSV, from a file into a mysql database from a shell. Log in to your mysql database and choose the database you are going to import into. Type in the following in the mysql console to import from the CSV file load data […]
Scripting
Read More
mySQL dump i batch mode
# mysql dbname -B -N -e “SELECT serial FROM serials” >/path/to/outfile -B or –batch: prints rows tab-separated and turns off the borders -N or –skip-column-names: leaves out the header row
Linux
Read More
Export mysql data to a tab-separated file
# mysqldump -u root -p –no-create-info -T=/tmp –fields-terminated-by=’\t’ db tabell
Linux
Read More
Copying One mySQL database from one machine to another
# mysqldump -h host.com -u root -p password sourceDB | mysql -h host2.com -u username -p password -C targetDB Interestingly, you don’t actually have be on the ‘source’ machine thanks to mySQL’s -h switch. From the target machine, simply specify the remote host after the -h. This was quite useful for me as my source […]