I have a web server which needs to link to a MS SQL server (not my choice). In my case I use Plack which calls the database in four steps. The catch I often struggle with is that some other files with the same name may float around and which you may not be aware off. Run therefore a “find / -name …
Read more →Posts tagged with
Database
Access denied for user ‘debian-sys-maint’@'localhost’
debian-sys-maint is a system MySQL user created to be able to start/stop the databases and to carry out maintenance operations. The above error message is therefore due to a mismatch between the mysql debian-sys-maint password in the mysql database and that in the configuration file /etc/debian.cnf. …
Read more →MySQL backup and restore
To backup a single database: mysqldump --user=root --password=password mydb > mydb.sql Yes it is no typo, there is no space between the -p and the password! You may like to add this to the my.cfg file in etc to avoid [mysqldump] events ignore-table=mysql.events If you didn’t use the …
Read more →