Skip to main content

Posts

Showing posts from 2019

Database Commands

************* Give PRIVILEGES to Database ************* GRANT SELECT, INSERT ON databasename.* TO 'root'@'192.168.100.32'; GRANT ALL PRIVILEGES ON *.* TO root@'192.168.100.32' IDENTIFIED BY 'dbpassword' WITH GRANT OPTION; FLUSH PRIVILEGES; ************* Import Database ************* Import Database mysql -u root -p db_name< /var/www/html/db_name.sql ************* Export Database ************* mysqldump -u root -p db_name > /var/www/html/db_name.sql ************* convert the folder into tar ************* tar -cvf tarfilename.tar foldername ************* convert the tar into folder ************* tar -xvf tarfilename.tar ************* Copy file from one folder to another folder ************* cp /var/www/html/demo/phpLinkedIn /var/www/html/ ************* Copy folder from one server to another server ************* scp -r foldername root@192.168.100.32:/var/www/html/ **** Localhost xampp database **** C:\xampp\mysql\bin Import...