PHP: retore big MYSQL-database
This tutorial shows you how to restore a big MYSQL-database. Step 1: split MYSQL file into many part We use PHP-script below (ex: split.php) After…
Tag: MYSQL
Change root password MYSQL in Kloxo via SSH
Step 1: Login VPS or dedicated server using SSH. Step 2: Open SSH console. Step 3: Use following commands: service mysqld stop mysqld_safe –skip-grant-tables &…
PHP & MYSQL: Determine Auto Increment value of a table
How to Determine Auto Increment value of a table MYSQL Method 1: Code PHP: Result: 84586 #Showing rows 0 – 0 ( 1 total, Query…
MYSQL: How to DELETE with INNER JOIN
MYSQL: How to DELETE with INNER JOIN There are 2 tables, proxy and proxy2, and I need to delete data from proxy. proxy.md5 = proxy2.md5…
How to install mytop
mytop is a ‘top’ clone for MySQL. mytop is a console-based (non-gui) tool for monitoring the threads and overall performance of MySQL 3.22.x, 3.23.x, and…