Tag Archive
Setting Up an Ubuntu Server
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.
How to Dump MySQL Tables Without Data
Use the mysqldump command with the –no-data option:
How to Output a MySQL Query to CSV
To output a MySQL query to a CSV file, the query needs to be altered.
How to Recover the MySQL root Password
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.
Installing Proftpd with MySQL in Ubuntu Linux
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 [...]
How to Rename a MySQL Table
To rename a MySQL table use RENAME TABLE with the old name then the new name after the TO keyword.
How to Delete a Field in a MySQL Table
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.
How to Rename a Field in a MySQL Table
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);