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!  

Posted on June 14, 2018 at 15:44 by arte · Permalink · Leave a comment
In: English, Fun, mySQL · Tagged with: ,

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

Posted on September 10, 2013 at 18:03 by arte · Permalink · Leave a comment
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’

Posted on July 8, 2013 at 16:07 by arte · Permalink · Leave a comment
In: English, mySQL

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 […]

Posted on February 14, 2012 at 21:33 by admin · Permalink · Leave a comment
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 […]

Posted on June 28, 2010 at 12:55 by admin · Permalink · Leave a comment
In: mySQL