Re: Connection Diagnostic Tool

2010-07-05 Thread Rob Wultsch
On Mon, Jul 5, 2010 at 3:55 PM, michel wrote: > > I have been trying to figure this one out, but I don't have the skill sets > here so I can use some help. > > I tried ' -h 127.0.0.1' in my bash shell and I get a command not found, so I > am still really off-the-mark. Is there a place on the net I

re: Connection Diagnostic Tool

2010-07-05 Thread michel
I have been trying to figure this one out, but I don't have the skill sets here so I can use some help. I tried ' -h 127.0.0.1' in my bash shell and I get a command not found, so I am still really off-the-mark. Is there a place on the net I can look up what it does and how to run it? Thank

Re: How to slim MySQL?

2010-07-05 Thread Michael Dykman
Go through that list of options and exclude anything you don't want or need. It is a very long list. - md On Mon, Jul 5, 2010 at 4:39 PM, Nima Mohammadi wrote: > > On Tue, Jul 6, 2010 at 12:54 AM, Michael Dykman wrote: >> >> As you are building from source, whats pre-compile configuration >>

Re: How to slim MySQL?

2010-07-05 Thread Michael Dykman
As you are building from source, whats pre-compile configuration options are you using? That will have everything to do with the size of your resulting binaries. - michael dykman On Mon, Jul 5, 2010 at 1:53 PM, Nima Mohammadi wrote: > On Mon, Jul 5, 2010 at 10:11 PM, Rob Wultsch wrote: > > >

Re: Got error 139 from storage engine (InnoDB)

2010-07-05 Thread Rob Wultsch
On Mon, Jul 5, 2010 at 9:06 AM, Rob Wultsch wrote: > On Sun, Jul 4, 2010 at 8:35 PM, James Corteciano > wrote: >> Hi All, >> >> I have received error message "ERROR 1030 (HY000) at line 167: Got error 139 >> from storage engine" when importing dump database to MySQL server. The MySQL >> server i

Re: Why is Host option Failing? *SOLVED*

2010-07-05 Thread Michael Satterwhite
On Monday, July 05, 2010 01:17:57 pm burhan.kha...@gmail.com wrote: > Michael: > > It could be that MySQL is only listening on localhost (127.0.0.1) and not > your net IP. Check your network settings in your server config. > Alternately, you can also do a > > netstat -anp | grep mysql > > As r

Re: Why is Host option Failing?

2010-07-05 Thread burhan . khalid
Michael: It could be that MySQL is only listening on localhost (127.0.0.1) and not your net IP. Check your network settings in your server config. Alternately, you can also do a netstat -anp | grep mysql As root and see where it is listening. Regards, -- Burhan Khalid Sent from my BlackBer

Re: How to slim MySQL?

2010-07-05 Thread Nima Mohammadi
On Mon, Jul 5, 2010 at 10:11 PM, Rob Wultsch wrote: > This is not a topic I have worked with previously. I image this may > be a good topic to bring to a consulting company (specifically Percona > and Open Query might work well) if you are unable to meet your size > goals. > > > > -- > Rob Wult

Re: Got error 139 from storage engine (InnoDB)

2010-07-05 Thread Prabhat Kumar
I think this is related to foreign key constraint data types don't match up... so verify your CREATE TABLE structure or post the CREATE TABLE statement for your table. Or there is chance of data type size and the value you are inserting.. such type of problem occurs if the data import ie source an

Re: How to slim MySQL?

2010-07-05 Thread Rob Wultsch
On Mon, Jul 5, 2010 at 10:07 AM, Nima Mohammadi wrote: > On Mon, Jul 5, 2010 at 8:26 PM, Rob Wultsch wrote: > >> >> Have you considered SQLite? >> >> You probably want to compile your own version of MySQL. You probably >> want to remove debugging symbols* (which have been present since the >> mid

Re: How to slim MySQL?

2010-07-05 Thread Nima Mohammadi
On Mon, Jul 5, 2010 at 8:26 PM, Rob Wultsch wrote: > > Have you considered SQLite? > > You probably want to compile your own version of MySQL. You probably > want to remove debugging symbols* (which have been present since the > mid 5.0 series, iirc), and any engines/character sets/etc you don't

Re: Why is Host option Failing?

2010-07-05 Thread Michael Satterwhite
On Monday, July 05, 2010 10:46:48 am Bob Cole wrote: > > The remote computer let me into mysql and I typed: > mysql> use mysql > mysql> select host, user, Password, Select_priv from user; > +--+--+---+ > -+ > > | host

Re: Got error 139 from storage engine (InnoDB)

2010-07-05 Thread Rob Wultsch
On Sun, Jul 4, 2010 at 8:35 PM, James Corteciano wrote: > Hi All, > > I have received error message "ERROR 1030 (HY000) at line 167: Got error 139 > from storage engine" when importing dump database to MySQL server. The MySQL > server is using InnoDB. I have google it and it's something problem on

Re: How to slim MySQL?

2010-07-05 Thread Rob Wultsch
On Mon, Jul 5, 2010 at 7:59 AM, Nima wrote: > Hi folks, > I'd like to install MySQL on an embedded system. It's a powerful x86-based > computer with the only limitation of having a small-size flash ROM as its > secondary storage. > I tried installing MySQL from source which resulted in occupying 1

Re: Why is Host option Failing?

2010-07-05 Thread Bob Cole
On Jul 5, 2010, at 10:04 AM, Michael Satterwhite wrote: >> [...snip...] >> On 5 July 2010 03:35, Michael Satterwhite wrote: >>> On Sunday, July 04, 2010 06:36:00 pm you wrote: >>> [...snip...] >>> I still can't connect via >>> mysql -h photon -u michael -p?? On my home computer I enter

Re: Why is Host option Failing?

2010-07-05 Thread Michael Satterwhite
On Monday, July 05, 2010 08:26:03 am you wrote: > Hi, > > dig should be in /usr/bin but its possible it isn't installed > I'm not sure about PcLinuxOS but it's in the dnsutils package on > debian/Ubuntu. As you said earlier, it's not necessary to use dig to check the ip address. Ping does the jo

How to slim MySQL?

2010-07-05 Thread Nima
Hi folks, I'd like to install MySQL on an embedded system. It's a powerful x86-based computer with the only limitation of having a small-size flash ROM as its secondary storage. I tried installing MySQL from source which resulted in occupying 140 MB of disk space, while the maximum amount of flash