Tag: mysql

  • How to reset wordpress user password using mysql

    login to the mysql #mysql -u -p /*use wordpress site database*/ mysql> show databases; mysql>use ; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed /*show database tables */ mysql>show tables; /*show users list */ mysql> SELECT ID, user_login,…

  • Mysql db backup batch script for windows

    This is an example of very simple mysql database backup batch script for windows machines: @echo off REM “MySql Backup Initiated” REM “Mysql username/password” SET mysqlUsername=”root” SET mysqlPassword=”root” REM “Creating folder with date stamp” set datestamp=%date:~-4,4%%date:~-10,2%%date:~7,2% mkdir D:\backup\dbBackup\mysql_%datestamp% SET backupDir=”D:\backup\dbBackup\mysql_%datestamp%” REM “Database backup Started” SET mysqlCmdDir=”c:\Program Files\MySQL\MySQL Server 5.5\bin” cd %mysqlCmdDir% mysqldump -uroot -proot exampledb…