For a single database: mysqldump –opt –user=root –password database1 > singledb.sql For multiple Backup of databases: mysqldump –opt –user=root –password –databases database1 database2 > multipledb.sql To import a MYSQL .sql file from one location to particular location : source /home/SSI/process_databases_backup.sql
If you want to loop throuh the mysql result set twice then use below way. $result = mysql_query(“SELECT * FROM my_table”);while($row = mysql_fetch_assoc($result)) {// inside the loop} The problem is, if you want to loop through the same result set again, you will get an error because the internal pointer is currently at the end […]
Below are some of the list of best Keyword Research Tools and SEO Tools. List of Research Tools and SEO Tools Google keyword research tool Google analytics Google webmaster tools Moz Market Samurai Raven FeedTheBot Majestic SEO Advanced Web Ranking SEM Rush Cemper’s link research tools Übersuggest Cognitive SEO SEO Site Checkup Brightedge Mondovo KeywordShitter Xovi […]
