Php, MySql, .htaccess: friendly urls

Php, MySql, .htaccess: friendly urls There are a lot of tutorials that show how to change an address like: www.mysite.com/products.php?product_id=1234 into others like: www.mysite.com/products/1234 www.mysite.com/products/1234.html In this article I’d like to go one step forward and to create something like: www.mysite.com/easy-to-remember-product-name www.mysite.com/easy-to-remember-product-name.html

Read More

mysql console backup restore

Question: How to backup the whole database? Answer: Just omit the “table_name” argument. For example, mysqldump -u root -pwordpress > D:\wordpress.sql Question: How to backup all the databases in MySQL? USE –force to continue on errors Answer: Use “–all-databases”. For example, mysqldump -u root -p –all-databases > D:\db.sql linux mysqldump -u admin -p –all-databases > db.sql Restoring Now let’s […]

Read More