Introduction This is tutorial on how to set up an Ubuntu server with apache, mysql, proftpd, webmin, setting up a user account and adding it to the sudoers list.
Use the mysqldump command with the –no-data option:
To output a MySQL query to a CSV file, the query needs to be altered.
Introduction If the root password for MySQL has been forgotten, there is a way to reset it. The process involves stopping the MySQL server and starting it in safe mode.
Introduction Proftpd is a modular FTP server that runs on Linux. One of the proftpd modules is for MySQL and enables users to be stored in the database instead of the system. Users can have a different home directories as they are set per user in the database, different quotas can be set for users [...]
To rename a MySQL table use RENAME TABLE with the old name then the new name after the TO keyword.
To delete a column in a MySQL database column, use the DROP COLUMN keywords with ALTER TABLE. Do not mistake deleting a field for deleting a record.
To change the name of a field in a MySQL database table use the CHANGE keyword with ALTER TABLE. You must also supply the field type again or you can change that too in the same line. Example: ALTER TABLE mytable CHANGE oldname newname VARCHAR(32);