Moving servers…

Sh*ts

Moving servers….

SERVER ONE http://colo-cation.com/

sent 2390501229464 bytes received 105496736 bytes 6636712.04 bytes/sec
total size is 2424713909072 speedup is 1.01

2.3TB

SERVER TWO http://cavecreek.com/

sent 643673812536 bytes received 25985160 bytes 7483706.60 bytes/sec
total size is 660370847119 speedup is 1.03

643Gb

SQLSTATE[HY000] [2000] mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication

Laravel, PHP, SQL

 

SQLSTATE[HY000] [2000] mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD(‘your_existing_password’). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file

This is a small script, made by Antonio Bonifati and found at StackOverflow Cannot connect to MySQL 4.1+ using old authentication  that will update your password and it will solve this problem for you.

<?php

$hostname = '127.0.0.1';
$database = 'database_name';
$username = 'database_username';
$password = 'password';

if (!mysql_connect($hostname, $username, $password)) {
 die(mysql_error());
} if (!mysql_query($query = 'SET SESSION old_passwords=FALSE')) {
 die($query);
} if (!mysql_query($query = "SET PASSWORD = PASSWORD('" .$password . "')")) {
 die($query);
}
echo "Excellent, mysqli will now work";

exit();
?>

Export & Import WordPress

Wordpress, , ,

I regularly work with WordPress… sometimes I install the working version on one of my servers and then move to the client’s server. Most of the times is a PAIN in the ass work…

I used to dump the mysql database, search and replace the older domain/subdomain for the new one and then import the database on the new server bla bla bla.

Users passwords stop working, themes and plugins sh*ts disappeared….

Yesterday I’v found a plugin who exports the DB PERFECTLY!

WP Migrate DB
https://wordpress.org/plugins/wp-migrate-db/

wp-migrate-db_reviews

Dedibox ST12

Sh*ts

st12-2015

RAID 0 offers no redundancy. It improves performance and provides additional storage but has no fault tolerance. If any drive failure occurs, the RAID array will be destroyed, with more drive in the RAID array failure probability is increased.

RAID 5 provides advanced data mirroring. Every drive contain data and a parity section which will be used to reconstuct the array in case of an hardware failure. A single drive can be missing without any data loss.

RAID 6 provides advanced data mirroring, similar to RAID 5 but in a more reliable way. Every drive contain data and a parity section which will be used to reconstuct the array in case of an hardware failure. Two drives can be missing without any data loss.

RAID 6 HERE WE GO!

raids