Backup a database from the shell prompt
Another technique for backing up a database is to use the mysqldump program or the mysqlhotcopy script. Create a full backup of your database: shell> …
Latest articles for category: Database
Use the Load DATA statement?
After creating your table, you need to populate it. The LOAD DATA and INSERT statements are useful for this. Suppose that your pet records can …
Secure the initial MySQL accounts?
Securing the Initial MySQL Accounts Windows distributions contain preinitialized grant tables that are installed automatically. On Unix, the grant tables are populated by the mysql_install_db …
Change ownership of a table through MS SQL
DECLARE @old sysname, @new sysname, @sql varchar(1000) SELECT @old = ‘oldOwner_CHANGE_THIS’ , @new = ‘dbo’ , @sql = ‘ IF EXISTS (SELECT NULL FROM INFORMATION_SCHEMA.TABLES …
Write a stored procedure for MS SQL
Connect to your database through an application such as Enterprise Manager, go to your database, right click stored procedures and select new. Below is a …
FTP through an MSSQL stored procedure
This stored procedure takes four parameters: file to ftp server name or IP ftp login ftp password SP will ensure that local file exists before …
Manage Database Roles
Solution Database roles are conceptually completely separate from operating system users. Database roles are global across a database cluster installation. To create a role use …
Manage Tablespaces
Tablespaces in PostgreSQL allow database administrators to define locations in the file system where the files representing database objects can be stored. Once created, a …
Copy MySQL database to another server through shell?
Copying MySQL Databases to another server If you are using MySQL 3.23 or later, you can copy the .frm, .MYI, and .MYD files for MyISAM …
Use mysql_fix_privilege_tables script
Solution mysql_fix_privilege_tables — Upgrade MySQL System Tables Some releases of MySQL introduce changes to the structure of the system tables in the mysql database to …
Delete a Database
Databases are destroyed with the command DROP DATABASE: DROP DATABASE name; Only the owner of the database, or a superuser, can drop a database. Dropping …
Showing 23 - 33 of 90 articles