The free forums are no longer in use. It remains available as read-only archive.
Log In
Home
Topic RSS
12:32 pm
May 9, 2014
Offline
Hello,
Thanks for this wonderful plug-in. Still, I have a little problem with mysqli connect.
The host adress that is extracted from wp-config is localhost:/tmp/mysql5.sock . The script give me the error:
Warning: mysqli::mysqli(): (HY000/2005): Unknown MySQL server host 'localhost:/tmp/mysql5.sock' (1)
Connect failed: %s
I did change in the Configuration > MYSQL the Mysql hostname to "localhost", "localhost:3306", "localhost:3317" nothing seem to work.
While putting localhost only, the error change to Warning: mysqli::mysqli(): (HY000/1045): Access denied for user: 'dboXXXXXXXX@localhost' (Using password: YES).
If this helps, I did have almost the same problem with PhpMyAdmin while configuring it, I was forced to give the port to the database, is there a way to do the same with Xcloner ?
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['socket'] = '/tmp/mysql5.sock';$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
Is there a way to connect to the database using another method (not mysqli) ? If i chose not to save the DB, can I export the SQL file with another tool (like Adminer or PhpMyAdmin) and then put it in tar file ? It will work ?
Thank you.
5:53 am
September 26, 2010
Offline
The mysql backup file is located in the administrator/backups/database-sql.sql file, so you can import that file through phpmyadmin.
Ovidiu
9:12 am
May 9, 2014
Offline
Hi Ovidiu,
The question was in the other direction: Made the sql export from PhpMyAdmin and integrate it in .tar file manualy since the script can't connect to the database in first place. Can you alter the script to have the port feature in Configuration > MySql ? Database is the most important elemement of a backup, since the files can be exported with many utilities like the file manager from Cpanel or Net2Ftp .
Is there a diference betwen the sql made by the script and the sql made by phpmyadmin ? (Drop, Insert Into, etc).
Thank you, have a nice day.
6:34 am
September 26, 2010
Offline
There is not difference between the two files, so that's not the issue. I think the issue you are having there is from the connect details, localhost is good for server name, you might need to recheck the mysql user and password.
Ovidiu
12:19 pm
May 9, 2014
Offline
Hi Ovidiu,
I still have the same problem, the details (database name,password) are correct. I have a dedicated server.
The connexion details for database extracted from WordPress config is:
define('DB_HOST', 'localhost:/tmp/mysql5.sock');So I tried the adress the message is
Warning: mysqli::mysqli(): (HY000/2005): Unknown MySQL server host 'localhost:/tmp/mysql5.sock' (1) in /homepages/amber/wp-content/plugins/xcloner-backup-and-restore/common.php on line 64
1 Guest(s)
