Ignore or skip some tables while dumping database

To ignore some tables while backingup database use the following..



mysqldump -u dave -ppassword -h localhost --ignore-table=my_db_name.my_table_name my_db_name > dump.sql

Comments

Post a Comment

Popular posts from this blog

How to Reset Root Password in Drupal 7 with phpMyAdmin

Image
Copy the hash.. $S$C6x2r.aW5Nkg7st6/u.IKWjTerHXscjPtu4spwhCVZlP89UKcbb/ (that’s the hash for newPassword ).   Navigate to your phpMyAdmin (likely in your control panel online somewhere). Then browse the User table for the Root user, look like his. Take the copied hashed text and paste it into the pass field of the Root user and hit “Go”. See this If you want to reset Drupal pasword using Drush .
Read more

Convert Putty ppk key to SSH key

You cant use a putty ppk to ssh to a remote server from you linux machine. In that case you may need to first convert ppk to ssh file. For that first you need to install putty on your machine. $ sudo apt-get install putty Then goto the directory and run the  following command to convert ppk to ssh file. $ puttygen key.ppk -O private-openssh -o key.ssh Here, I assume, kep.ppk is you ppk file and key.ssh will be newly created ssh file. After this you can ssh to your remote machine/server using following command. $ ssh user@myserver.com -i key.ssh
Read more