mysql

Change file:  /etc/my.cnf

Here it is for others who wish to increase the upload limit from 2M to whatever you desire:

Change the following file: /usr/local/psa/admin/conf/php.ini

And the following value: “upload_max_filesize” & “post_max_size” From “2147483647″ to “100M” (100M or whatever value you wish to set the cap to)

You will then need to run the following commands to reset Apache for the changes to take effect:

/etc/init.d/psa stop
/etc/init.d/psa start

Source: http://blog.mattsatorius.com/technology/web-design/how-to-change-the-max-file-upload-size-for-phpmyadmin-in-plesk/

Will set all rows as enabled

UPDATE Catalog SET Status='Enabled'

Edit file:

/etc/my.cnf

Comment out line:

skip-networking

So should look like this:

#skip-networking

Restart MySQL

/etc/init.d/mysqld restart

To find a string in a certain field and replace it with another string:

update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');

Source: http://www.mediacollege.com/computer/database/mysql/find-replace.html

To start mysql server:

/etc/init.d/mysqld start

To stop mysql server:

/etc/init.d/mysqld stop

To restart mysql server

 /etc/init.d/mysqld restart

Source: http://theos.in/desktop-linux/tip-that-matters/how-do-i-restart-mysql-server/

Comment out “skip-networking parameter” in /etc/my.cnf

cat ~mysql/.my.cnf

Run this command on the command line to load a mysql database dump file

mysql -u yourusername -p -h localhost databasename < data.sql

Run this command to dump a database via command line

mysqldump –u yourusername –p yourdatabasename > yourdumpfile.sql