database administration – Page 2 – CodeRavo

Restoring MySQL Databases from Dump Files

Restoring MySQL Databases from Dump Files MySQL dump files are commonly used for backing up and … Restoring MySQL Databases from Dump FilesRead more

backup, Command Line, data, database, database administration, Import, MySQL, mysqldump, restore, SQL

Resetting the MySQL Root Password

Resetting the MySQL Root Password MySQL is a widely used open-source relational database management system. A … Resetting the MySQL Root PasswordRead more

authentication, Command Line, database, database administration, MySQL, mysqld-safe, reset-password, root password, Security, SQL

Understanding and Resolving Oracle's ORA-00054 Error

Understanding and Resolving Oracle’s ORA-00054 Error The ORA-00054: resource busy and acquire with NOWAIT specified or … Understanding and Resolving Oracle's ORA-00054 ErrorRead more

database, database administration, deadlock, locking, ora-00054, oracle, performance-tuning, SQL, transactions

Renaming Columns in SQL Server

SQL Server provides a mechanism to rename columns within a table, allowing you to modify your … Renaming Columns in SQL ServerRead more

database administration, Database Management, database schema, rename-column, sp-rename, SQL, SQL Server, T-SQL, transact-sql

Calculating Table Size in SQL Server

Calculating the size of tables in a SQL Server database is an essential task for database … Calculating Table Size in SQL ServerRead more

database administration, SQL Server, storage-optimization, system views, table-size

MySQL Authentication and Password Management

MySQL is a popular relational database management system that requires authentication to access its features. In … MySQL Authentication and Password ManagementRead more

authentication, database administration, MySQL, password management, Security