Archive for the ‘mySQL’ Category
Little PHP script to create MySQL table from CSV/TSV/Excel file with or without data
Recently I needed a little tool to create many DB tables in MySQL from Excel/CSV docs and as an outcome of that I’ve created this little tool: https://github.com/aarefjev/csv_to_mysql It’s a little buggy I suppose, but does what it’s supposed to. Have fun!
In: English, Fun, mySQL · Tagged with: csv, php
How quickly copy one DB to another
Well, this is quite simple actually: mysqldump -u db_user -pYourPass -h 127.0.0.1 database_name_from | mysql -u db_user -pYourPass -h 127.0.0.1 database_name_to
In: English, Linux, mySQL, Ubuntu
How to add new MySQL user from the command Line
Very simple actually. GRANT ALL PRIVILEGES ON *.* to root@127.0.0.1 identified by ‘secretpassw0rd’
Problems with mysql installation on Windows 7? Have been there…
Hi Folks! Today I run into an interesting problem with installation of MySQL on my new Windows 7 / 64bit. MySQL just didn’t want to be installed! And stopped during confuguration process. Tried many things, googled for solution, but in most of the cases people said something like this “as this is not your first […]
In: English, Fighting the system, mySQL
Backup & Restore mySQL database | quick guide
Create a backup: mysqldump -u username -p password –databases database1 database2 db_name3 > multi_db_names.sql mysqldump –all-databases > alldatabases.sql mysqldump –all-databases | bzip2 -c > databasebackup.sql.bz2 mysqldump –all-databases | gzip > databasebackup.sql.gz Restore from a backup: mysql -u [username] -p [password] [database_to_restore] < [backupfile] gunzip < backup_name.sql.gz | mysql -u username -p password db_name If you […]