MySQL export large db
mysqldump -u user-p –max-allowed-packet=1G …. mysql -u use -p –max-allowed-packet=1G ….
Category: MySQL
XAMPP – Batch script to backup all MySQL databases
Create a the folder c:\xampp\backup Create the file mysql_all_databases.bat inside c:\xampp with […]
Create a database with charset utf-8
CREATE DATABASE mydatabase CHARACTER SET utf8 COLLATE utf8_general_ci; or CREATE DATABASE mydatabase […]
MySQL find and replace string
If you want to search for a string inside a table and […]