Import the database using the CMD prompt on Windows

Import the database using the CMD prompt on Windows

Step 1: Go to Run Command [Win+R] and type CMD and click on OK to open CMD prompt Step 2: Navigate to following folder path “wamp\bin\mysql\mysql5.5.24\bin” using command line [ex: cd D:\wamp\bin\mysql\mysql5.5.24\bin] Step 3: Type this mysql -u username -p -h localhost DATA-BASE-NAME < data.sql with your updated data on command prompt Step 4: Finally […]

Frequently used Putty commands

Frequently used Putty commands

Database Dump: mysqldump -u username -h localhost -p dbname > filename.sql Import Database Dump: mysql -u username -p -h localhost DATA-BASE-NAME < data.sql Tar a folder: tar -cv foldername > foldername.tar GZip the tar file: gzip foldername.tar Extract tar.gz file: tar -zxvf yourfile.tar.gz Extract .bz2 file: bunzip2  yourfile.bz2 Extract tar.bz2file: tar jxf backup.tar.bz2 Copy files […]