Prepare the data so that when it gets added to your SQL query it doesn’t break the server ( Defence SQL injection attack ).
When a form has been submitted via GET or POST all data is stored in the ...
Categories: MySQL, PhP, Tech Tags: attack, cookie, escape string, GET, Injection, POST, query, request, SQL, stripslashes
If the mysql log - /var/log/mysqld.log (fedora distro) - says:
090728 02:56:59 mysqld started
090728 2:56:59 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
090728 2:56:59 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
090728 2:56:59 [ERROR] Fatal error: Can't ...
Linux - for mysql tunning use MySQLTuner script. MySQLTuner is a script written in perl that will assist you with your MySQL configuration & make recommendations for increased performance and stability.
Download the latest MySQLTuner version in plain text to your ...
1'st Solution, use Mysql COUNT(*) :
$sql = "SELECT COUNT(*) FROM my_table";
$result = mysql_query($sql);
$num = mysql_result($result, 0);
echo $num;
2'nd solution: use TABLE_ROWS and TABLE_NAME from information_schema:
$query = "select TABLE_ROWS from information_schema.tables where table_schema = 'my_data_base' AND TABLE_NAME = 'my_table' ";
$result = mysql_query($query);
$count ...
Categories: Bookmarks, MySQL, Networking, PhP, Tech Tags: get count row, information_schema, Mysql COUNT, mysql row counts, SELECT COUNT, TABLE_NAME, TABLE_ROWS, table_schema
Solution is simple, use mysql_insert_id() php function.
mysql_insert_id() returns the value generated for an AUTO_INCREMENT column by the previous INSERT or UPDATE statement. Use this function after you have performed an INSERT statement into a table that contains an AUTO_INCREMENT field, ...
How to recover accidentally deleted MySQL database files if someone accidentally removed all table files from a MySQL Server's data directory with a linux shell script? Will be surprised to find out that the linux server continued to serve requests ...
Categories: Bookmarks, Linux, MySQL, Networking, PhP, Tech Tags: accidentally removed table, INTO OUTFILE, INTO TABLE, LOAD DATA INFILE, MySQL recover tables, mysqld process, mysqldump recover, phpMyAdmin import, rm command
There are basically 2 ways suggested method:
1st, save/copy the database table and use text editor's "search and replace" function and fill table with new content;
2'nd , use MySQL REPLACE function:
UPDATE table_name SET column_name = REPLACE(column_name,"original_text","replace_text")
Categories: Blogs, Bookmarks, MySQL, Tech, Web Tags: Mass Replace Mysql, Mass Replace String, Mass Replace Text, MySQL REPLACE, MySQL REPLACE function, SET column_name, UPDATE table_name
Z O E Y - Z A N E , este cauza pentru care astazi mai tot timpul am fost OffLINE. Observati ca nici nu am mai scris impreunat ;) iar in titlu am inlocuit din caractere ... nu mai ...
Categories: Bookmarks, Hosting, Linux, MySQL, Networking, PhP, Web, Wordpress, de Necrezut Tags: high trafic, huge trafic, server overloading, trafic
use MySQL REPLACE function!
1. BACKUP YOUR DATABASE FIRST.
2. From within phpMyAdmin, open your database.
3. And here is the SQL query to replace string in database table:
UPDATE table_name SET column_name = REPLACE(column_name,"original_string","replace_string")
How to Repair MySQL Tables ?
1. Login on server
2. Type next linux command in your mysql folder with MYI files :
myisamchk -r --sort-index --analyze *.MYI
folder ex: /var/lib/mysql/yourdatabase/
*NOTE:
- DO NOT TYPE ANYTHING BEFORE BACKUP DATABASE!
- If you request warnig about table ...
