How to Dump just the table structure file in MySQL

How to Dump just the table structure file in MySQL The mysql dump utility can be used as like taking the mysql database Syantax will be mysqldump -d -h localhost -u root -p databasename > dumpfile.sql The only option that is different than creating an entire backup is the -d switch, which tells mysqldump not […]

Adding an Addon Domain on CPANEL

Adding an Addon Domain on CPANEL

Creating Mysql Database Users and Changing Password using Sell

Creating Mysql Database Users and Changing Password using Sell Create a new user.INSERT INTO [table name] (Host,User,Password) VALUES(‘%’,’user’,PASSWORD(‘password’)); Change a users password.(from unix shell).mysqladmin -u root -h hostname.blah.org -p password ‘new-password’ Change a users passwordSET PASSWORD FOR ‘user’@’hostname’ = PASSWORD(‘passwordhere’); Allow the user “karthick” to connect to the server from localhost using the password “passwd123” […]

Add content in database table

1.To add contents in the database table click on the insert tab on the phpmyadmin 2.clcik on the fields and update the data 3.At the bottom of the page you will see a drop-down menu called insert with x rows . There you can pick the number of the rows that you can insert with […]

MYSQL Error No. 1033 Incorrect information in file: ‘filename’

MYSQL Error No. 1033 if the specified file is corrupted Then MYSQL it will through the following error message. “Error No. 1033 Incorrect information in file: ‘filename’” Just restore that file we can resolve these problem. if that MYSQL file is corrupted then it will not find out that file field so it will through […]