[fusion_builder_container hundred_percent="yes" overflow="visible"][fusion_builder_row][fusion_builder_column type="1_1" background_position="left top" background_color="" border_size="" border_color="" border_style="solid" spacing="yes" background_image="" background_repeat="no-repeat" padding="" margin_top="0px" margin_bottom="0px" class="" id="" animation_type="" animation_speed="0.3" animation_direction="left" hide_on_mobile="no" center_content="no" min_height="none"][mysql dir]/bin/mysql -h hostname -u root -p Create a database on the sql server. create database [databasename]; List all databases on the sql server. show databases; Switch to a database. use [db name]; To see all the tables in the db. show tables; To see database's field formats. describe [table name]; To delete a db. drop database [database name]; To delete a table. drop table [table name]; Show all data in a table. SELECT * FROM [table name]; Returns the columns and column information pertaining to the designated table. show columns from [table name]; Show certain selected rows with the value "whatever". SELECT * FROM [table name] WHERE [field name] = "whatever"; Show all records containing the name "Bob" AND the phone number '3444444'. SELECT * FROM [table name] WHERE name = "Bob" AND phone_number = '3444444'; Show all records not containing the name "Bob" AND the phone number '3444444' order by the phone_number field. SELECT * FROM [table name] WHERE name != "Bob" AND phone_number = '3444444' order by phone_number; Show all records starting with the letters 'bob' AND the phone number '3444444'. SELECT * FROM [table name] WHERE name like "Bob%" AND phone_number = '3444444'; Use a regular expression to find records. Use "REGEXP BINARY" to force case-sensitivity. This finds any record beginning with a. SELECT * FROM [table name] WHERE rec RLIKE "^a$"; Show unique records. SELECT DISTINCT [column name] FROM [table name]; Show selected records sorted in an ascending (asc) or descending (desc). SELECT [col1],[col2] FROM [table name] ORDER BY [col2] DESC; Return number of rows. SELECT COUNT(*) FROM [table name]; Sum column. SELECT SUM(*) FROM [table name]; Join tables on common columns. select lookup.illustrationid, lookup.personid,person.birthday from lookup left join person on lookup.personid=person.personid=statement to join birthday in person table with primary illustration id; Switch to the mysql db. Create a new user. INSERT INTO [table name] (Host,User,Password) VALUES('%','user',PASSWORD('password')); Change a users password.(from unix shell). [mysql dir]/bin/mysqladmin -u root -h hostname.blah.org -p password 'new-password' Change a users password.(from MySQL prompt). SET PASSWORD FOR 'user'@'hostname' = PASSWORD('passwordhere'); Allow the user "bob" to connect to the server from localhost using the password "passwd" grant usage on *.* to bob@localhost identified by 'passwd'; Switch to mysql db.Give user privilages for a db. INSERT INTO [table name] (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv) VALUES ('%','databasename','username','Y','Y','Y','Y','Y','N'); or grant all privileges on databasename.* to username@localhost; To update info already in a table. UPDATE [table name] SET Select_priv = 'Y',Insert_priv = 'Y',Update_priv = 'Y' where [field name] = 'user'; Delete a row(s) from a table. DELETE from [table name] where [field name] = 'whatever'; Update database permissions/privilages. FLUSH PRIVILEGES; Delete a column. alter table [table name] drop column [column name]; Add a new column to db. alter table [table name] add column [new column name] varchar (20); Change column name. alter table [table name] change [old column name] [new column name] varchar (50); Make a unique column so you get no dupes. alter table [table name] add unique ([column name]); Make a column bigger. alter table [table name] modify [column name] VARCHAR(3); Delete unique from table. alter table [table name] drop index [colmn name]; Load a CSV file into a table. LOAD DATA INFILE '/tmp/filename.csv' replace INTO TABLE [table name] FIELDS TERMINATED BY ',' LINES TERMINATED BY 'n' (field1,field2,field3); Dump all databases for backup. Backup file is sql commands to recreate all db's. [mysql dir]/bin/mysqldump -u root -ppassword --opt >/tmp/alldatabases.sql Dump one database for backup. [mysql dir]/bin/mysqldump -u username -ppassword --databases databasename >/tmp/databasename.sql Dump a table from a database. [mysql dir]/bin/mysqldump -c -u username -ppassword databasename tablename > /tmp/databasename.tablename.sql Restore database (or database table) from backup. [mysql dir]/bin/mysql -u username -ppassword databasename < /tmp/databasename.sql Create Table Example 1. CREATE TABLE [table name] (firstname VARCHAR(20), middleinitial VARCHAR(3), lastname VARCHAR(35),suffix VARCHAR(3),officeid VARCHAR(10),userid VARCHAR(15),username VARCHAR(8),email VARCHAR(35),phone VARCHAR(25), groups VARCHAR(15),datestamp DATE,timestamp time,pgpemail VARCHAR(255)); Create Table Example 2. create table [table name] (personid int(50) not null auto_increment primary key,firstname varchar(35),middlename varchar(50),lastnamevarchar(50) default 'bato'); [/fusion_builder_column][/fusion_builder_row][/fusion_builder_container]

How to install Mysql Via RPM : Please check the following link and get RPM http://httpupdate.cpanel.net/mysqlinstall/ in above list (not rpm) click on the version for which you want to install mysql than click on the operation system than on the version of operating system here you should download RPM for devel….development server…. client…. Shared….and Bench…. Download them on your server and install them (all with one command ) rpm –Uvh *rpm How to Upgrade Mysql On Cpanel: When a Client ask to update the Mysql than check these things I ) Whether he is on VPS (go to billing and check) II ) Whether he is on Cpanel or not … for this go to /usr/local…. Here must be cpanel Go to WHM and change the MySql version (tweak settings > mysql) and than in shell run /scripts/mysqlup Than you have to run /scripts/easyapache. When you update the mysql than you will have to recompile the php because whenever you run the php it is using the mysql libraries, so when you update the mysql it is essential for php to update …. So easyapache recompile the php and it also update the apache server. /scripts/easyapache Check the version of php with this command Php –v Now check the file Usr/local/apache/conf/httpd.conf And see whether the lines are commented or not If commented …. It means that php is running as a cgi scripts If not commented…it means that php is running as a apache module LoadModule php4_module libexec/libphp4.so -- as apache module #LoadModule php4_module libexec/libphp4.so --as cgi module There is difference in ownership when it is running as a cgi script or running as a apache module. Downgrade mysql on Cpanel: If a client ask you to downgrade mysql to some earlier version, than it must be kept in mind that the databases may not work for some earlier version, for this you have to take the dump of mysql in such a way which should be compatible to earlier version, for this you can use the following command., mysqldump -u root -p --create-options --compatible=mysql40 db_name > db_name.sql where 40 is 4.0 , you can change this value with some for which you want to create a dump. Better to ask the client to perform this step himself, as this is end user task. But it is essential to warn him with this problem before moving any further. Upgrade/install mysql on directadmin http://www.howtoforge.com/lighttpd_mysql_php_debian_etch How to upgrade Mysql on Interworx some times there may be some dependencies on the server, you have to resolve those dependencies. rpm -ihv http://mirror.steadfast.net/misc/iworx/php52/cos5/i386/iworx-php-release-5.2-1.steadfast.noarch.rpm yum remove php-pdo yum update php service httpd restart

FAQs Archive | Page 5 of 13 | Pakish Web Designing

Q: Repairing MySQL tables that will not open

This should be handled on a case by case basis, but if you are using the default MySQL table type of MyISAM (which is the default storage engine unless changed or specified differently) here are a few options: Repairing MySQL tables The myisamchk utility can be run from a command line to checks, repairs, or optimizes tables. It is normally run while the database is not running. For more information about myisamchk visit the MySQL website. mysqlcheck is similar in function to myisamchk, but can be run while the database is running. For more information about mysqlcheck visit the MySQL website. If you login to the database, you can also run sql commands that might fix your problem. Examples: mysql> optimize table your-tablename; mysql> analyze table your-tablename; mysql> repair table your-tablename; For more information about table maintenance SQL visit the MySQL website. If you are getting MySQL error numbers and are not sure what they are. From a command line you can use the perror utility to lookup errors. For more info on perror visit the MySQL website. Examples: shell> perror 13 64 Error code 13: Permission denied Error code 64: Machine is not on the network

Q: How to reset a mySQL password?

If you have lost your root user password for MySQL, you can reset it with the following procedure: Take down the mysqld server by sending a kill (not kill -9) to the mysqld server. The pid is stored in a .pid file, which is normally in the MySQL database directory: Example: shell> kill `cat /your-mysql-data-directory/hostname.pid` In Red Hat you can also stop the databse with: Example: shell> service mysqld stop You must be either the Unix root user or the same user the server runs as to do this. Restart mysqld with the --skip-grant-tables option. Connect to the mysqld server with Option 1 :mysql -h hostname mysql and change the password with a GRANT command. See MySQL website: MySQL: 7.35 GRANT and REVOKE Syntax Option 2 : shell> mysqladmin -h hostname -u user password 'new password' Load the privilege tables with: "shell> mysqladmin -h hostname flush-privileges” or with the SQL command "mysql> FLUSH PRIVILEGES;" . Note: Note that after you started mysqld with --skip-grant-tables, any usage of GRANT commands will give you an Unknown command error until you have executed FLUSH PRIVILEGES.

Q: How do I upload website?

Upload Website You can upload your site using any FTP program. The FTP server is ftp.yourdomain.com and the login and password is the hosting account login/password. Alternatively you can upload your site using the File Manager in your control panel. Need any more help please submit the ticket, on given link. https://pakish.pk/portal/submitticket.php