mysql

Setting Up an Ubuntu Server

21 February , 2012 Bill Linux

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.

More

8 apache, how to, installing, linux, mysql,

How to Dump MySQL Tables Without Data

10 October , 2011 Bill MySQL Database

Use the mysqldump command with the –no-data option:

More

0 how to, linux, mysql, tutorial, ubuntu,

How to Output a MySQL Query to CSV

9 September , 2011 Bill MySQL Database

To output a MySQL query to a CSV file, the query needs to be altered.

More

0 csv, how to, mysql, server, tutorial,

How to Recover the MySQL root Password

31 August , 2011 Bill MySQL Database

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.

More

0 how to, linux, mysql, server, tutorial,

Installing Proftpd with MySQL in Ubuntu Linux

29 August , 2011 Bill 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 […]

More

6 how to, installing, linux, mysql, proftpd,

How to Rename a MySQL Table

23 August , 2011 Bill MySQL Database

To rename a MySQL table use RENAME TABLE with the old name then the new name after the TO keyword.

More

0 how to, linux, mysql, osx, server,

How to Delete a Field in a MySQL Table

27 July , 2011 Bill MySQL Database

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.

More

1 how to, linux, mysql, osx, server,

How to Rename a Field in a MySQL Table

27 July , 2011 Bill MySQL Database

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);

More

0 how to, linux, mysql, osx, server,

Powered by WordPress. Designed by elogi.