|
FreeBSD General Other questions regarding FreeBSD which do not fit in any of the categories below. |
|
Thread Tools | Display Modes |
|
|||
Can't import mysql wordpress into jail
Hi there
I installed FAMP+wordpress in a jail. I'm trying to import the wordpress database from a linux server. mysqldump completed on this Linux server with no errors. Also I can connect to the wordpress admin page on the FreeBSD host from other hosts on the network. The wordpress database has been created and the privileges have been set according to this. However when i do: # Code:
mysql -u root -p wordpress < /root/word_dump.sql Code:
Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) I'e googled but only found, mostly stuff on phpmyadmin and quite a lot of unanswered stuff. I tried --skip-grants-table in various combinations(with -u root -p, with just -u root, on it's own) to no avail. It said unknown option. I'm not wanting you to trawl through the masses of stuff on mysql errors. I just thought someone might already know opr have experienced something similar! Any help would be great thankyou for any replies Last edited by unixjingleman; 25th July 2012 at 09:04 PM. |
|
|||
Oh i've just tried logging in to this jailed mysql from the Linux server. It didn't let me even though all the firewalls on the network were disabled. If it had let me i would have tried sending the database through the network
regards |
|
|||
You could edit the database dump and separate the dump of the 'mysql' user database, (the one with the grant tables) from the wordpress database.
Then import the wordpress-only database.
__________________
You don't need to be a genius to debug a pf.conf firewall ruleset, you just need the guts to run tcpdump |
|
|||
I've set bind-address to 0.0.0.0 in /etc/my.cnf and then on the commandline used --password=password, and the command returned without errors. I take it that it means that it was imported o.k?. Dunno wither to mark it as solved yet but will do as soon as i know
thankx for the reply(and any future replies!) regards unixjingleman |
|
|||
Erm dunno howto write [solved] in the thread title but the above did the trick
regards Last edited by unixjingleman; 29th July 2012 at 05:30 PM. |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Tools to assist in database import | J65nko | Guides | 3 | 12th December 2011 04:03 PM |
MySQL database import not helpful | J65nko | General software and network | 2 | 10th December 2011 02:45 AM |
WordPress 3.0 nearly complete | J65nko | News | 0 | 9th June 2010 06:28 PM |
zfs import | terryd | FreeBSD General | 1 | 23rd November 2008 09:26 PM |
import physical freeBSD into VMWARE (ESX) server as a vServer | ccc | FreeBSD General | 6 | 3rd October 2008 07:04 AM |