DaemonForums  

Go Back   DaemonForums > FreeBSD > FreeBSD General

FreeBSD General Other questions regarding FreeBSD which do not fit in any of the categories below.

Reply
 
Thread Tools Display Modes
  #1   (View Single Post)  
Old 24th July 2012
unixjingleman unixjingleman is offline
Fdisk Soldier
 
Join Date: Jan 2011
Posts: 70
Thanked 0 Times in 0 Posts
Default 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
i get this error:
Code:
Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
The word_dump.sql got moved with mv to /root in the jail before running the above command.
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.
Reply With Quote
  #2   (View Single Post)  
Old 25th July 2012
unixjingleman unixjingleman is offline
Fdisk Soldier
 
Join Date: Jan 2011
Posts: 70
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #3   (View Single Post)  
Old 25th July 2012
J65nko J65nko is offline
Administrator
 
Join Date: May 2008
Location: Budel - the Netherlands
Posts: 3,198
Thanked 182 Times in 149 Posts
Default

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
Reply With Quote
  #4   (View Single Post)  
Old 25th July 2012
unixjingleman unixjingleman is offline
Fdisk Soldier
 
Join Date: Jan 2011
Posts: 70
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #5   (View Single Post)  
Old 25th July 2012
unixjingleman unixjingleman is offline
Fdisk Soldier
 
Join Date: Jan 2011
Posts: 70
Thanked 0 Times in 0 Posts
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

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


All times are GMT. The time now is 12:27 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content copyright © 2007-2010, the authors
Daemon image copyright ©1988, Marshall Kirk McKusick