Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MYSQL


SuperbHosting.net have generously sponsored dedicated servers to ensure a reliable and scalable dedicated hosting solution for BigResource.com.





Starts And Ends


--Apple-Mail-2-720579055
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
charset=US-ASCII;
format=flowed

when I enter:
cd /usr/local/mysql
sudo chown -R mysql data/
sudo echo
sudo ./bin/mysqld_safe &

mysqld starts and ends. I am using a Mac with OSX 10.2.4 and have
installed 4.0.4

Any assistance would be greatly appreciated!

Helen
--Apple-Mail-2-720579055--




View Complete Forum Thread with Replies

Related Forum Messages:
Field Starts
How do you do a search for checking if the field starts with a certain value. What I am trying to do is search article titles for titles that start with "a" or "b" or "c" etc. Basically like on websites where you can find products by clicking on a list of letters. Do I need to grab all the articles and manually check this or can I do this in MySQL?

View Replies !
Id Starts From 1 After TRUNCATE
is it possible to let the id of a table to count from 1 afted it's been truncated?

View Replies !
Starts With A Number
Is it possible in a query to select all the records that have a number (as opposed to a letter) as the first character in a particular field? If so, how would you word the query

View Replies !
Insert 'http://' Where Row Starts With Www.
I need to insert "[url]http://"[/url]; to the beginning of each row where a URL has been entered as www.anything.com (for example) to the row becomes (http://www.anything.com)

I don't know how I can do this without over writting all the current URL's with out the prefix "[url]http://"[/url]; in a URL and whether it can be done.

View Replies !
Zip Code Column Set As Integer... Removes Extra 0 If Zip Code Ends In A 0
put my zip code column as an integer and not varchar, so now if the rows have a zip code that ends with a 0 it will discard it (for example zip code 64840 will get stored as 6484).

What query can I run to fix this problem to add a zero if the zip code column has 4 digits?

View Replies !
Auto-increment Starts On Highest Value
When this has been created, the ID has been generated to 2147483647 and when I try and create another record it fails because nothing can go higher than 2147483647 (I think)

The auto-increment has been started at 2147483647 no idea why, and from there when I atmysqlt to create another record it will fail because it ascends from that value.

View Replies !
Mysql Starts Multiple Php-instances
i have a little problem with a server, running mysql and php. I don't know which php-version i am working with, but the following is the answer for 'mysql --version'

mysql Ver 11.18 Distrib 3.23.52, for suse-linux (i686)

I know, that this version is not the newest one, but thats not my business.

My problem is that i need to execute a script, which starts mysql with this command:

mysql -hlocalhost -uuser -ppass db < $update > $update_log

whenever this command is running and the 800k $update file is working on the db (a lot of delete and insert statements) there are several php-instances created.

So many that they are slowing-down the server, that he is unusable.

View Replies !
Ereg String Starts With Number
Does anyone know the ereg syntax for MySQL to return results that start with a number?

E.g.

ereg('[0-9']*, $string);

but for an SQL statement.

View Replies !
Mysqld_multi Don't Starts Groups On Linux RedHat 9
mysqld_multi doesn't start the two groups if I gave this command imediately after stopping them.

View Replies !

Copyright © 2005-08 www.BigResource.com, All rights reserved