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

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 job.

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 mich...@weblore.com 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

Re: How to slim MySQL?

2010-07-05 Thread Rob Wultsch
On Mon, Jul 5, 2010 at 7:59 AM, Nima nima@gmail.com 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

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 ja...@linux-source.org 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

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: How to slim MySQL?

2010-07-05 Thread Nima Mohammadi
On Mon, Jul 5, 2010 at 8:26 PM, Rob Wultsch wult...@gmail.com 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

Re: How to slim MySQL?

2010-07-05 Thread Rob Wultsch
On Mon, Jul 5, 2010 at 10:07 AM, Nima Mohammadi nima@gmail.com wrote: On Mon, Jul 5, 2010 at 8:26 PM, Rob Wultsch wult...@gmail.com 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

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

Re: How to slim MySQL?

2010-07-05 Thread Nima Mohammadi
On Mon, Jul 5, 2010 at 10:11 PM, Rob Wultsch wult...@gmail.com 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. --

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

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 root and

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 wult...@gmail.com wrote: On Sun, Jul 4, 2010 at 8:35 PM, James Corteciano ja...@linux-source.org 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

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 nima@gmail.com wrote: On Mon, Jul 5, 2010 at 10:11 PM, Rob

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 nima@gmail.com wrote: On Tue, Jul 6, 2010 at 12:54 AM, Michael Dykman mdyk...@gmail.com wrote: As you are building from source, whats

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?

Re: Connection Diagnostic Tool

2010-07-05 Thread Rob Wultsch
On Mon, Jul 5, 2010 at 3:55 PM, michel compu...@videotron.ca 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