MyTechForum
database
-
How do I find duplicate values in my MySQL database table?
To find duplicates in a MySQL database table, you can run a query like the following: select column_name, count(*) as count from...
-
How do I delete unapproved WordPress comments from my MySQL database?
Sometimes when you fall behind in moderating your WordPress site you end up with a lot of comments from spammers, bots, etc....
-
How do I count the number of occurences of a value in a MySQL table?
For example, if you have some similar records that you want to calculate in your MySQL database, you can run a SQL...
-
How do I determine the SGA size for my Oracle database?
sql> SHOW SGA; or sql> SELECT name,value/1024/1024 “SGA (MB)” “FROM v$sga; You can display the total SGA size by using the SQL...
-
How do I delete a record from my MySQL database?
Deleting a record from your MySQL database is pretty easy, but it’s always good to confirm the delete before doing so. For...
-
How do I reset my MySQL root password if I have forgotten it?
1) Login to mysql server, type the following command at shell prompt: # /etc/init.d/mysql stop 2) Start mysqld_safe using the command below:...
-
How do I query my MySQL database for a particular column?
If you’re looking to find a particular column name on your MySQL server, you can use a query like the following: select...
-
How do I run a mysqldump on my MySQL Linux server?
The following script can be used to create a mysqldump by schema name: #!/bin/bash TODAY=$(date +%m”-“%d”-“%Y) HOSTNAME=$(hostname -s) for db in $(echo...
-
How do I set up replication on my Linux MySQL database server?
1. Install MySQL (mysql-server) on the master and slave servers if it’s not already installed. You can do so using ‘yum install...