Ubuntu Following Unix Post-installation Procedure
I'm following "2.4.16.2. Unix Post-Installation Procedures" in the manual. My OS is Ubuntu. I didn't have to initialise the grant tables because this was already done automatically during the install I'm sure. The reason I think this is that during install it asked me to set a password for root.
Anyway, I'm up to step 3.
It says to start the server for the first time I must execute the following command.
shell> bin/mysqld_safe --user=mysql &
so I got to /usr/bin/ and type "mysqld_safe --user=mysql &"
I get an odd response. Here is what the command line interface looks like.
bucephalus@Magnus:/var/run/mysqld$ /usr/bin/mysqld_safe --user=mysql &
[1] 7234
bucephalus@Magnus:/var/run/mysqld$ nohup: ignoring input and redirecting stderr to stdout
Starting mysqld daemon with databases from /var/lib/mysql
mysqld_safe[7273]: started
STOPPING server from pid file /var/run/mysqld/mysqld.pid
mysqld_safe[7283]: ended
First, I want to know where "--user=mysql" comes from? I didn't create that user.
Second, before I got this response I got some errors about two files, /var/run/mysqld/mysqld.pid and /var/run/mysqld/mysqld.sock stating that these couldn't be deleted, so I removed them manually. Does anypone have any ideas why I can't start the server?
View Complete Forum Thread with Replies
Related Forum Messages:
Php 5.1.6 With MySql 5.0 On Ubuntu 6.06
I am new to Ubuntu 6.06. I downloaded and installed apache 2.2.3 successfully on Ubuntu. I also downloaded Php 5.1.6. MySQL 5 is already loaded on my Ubuntu. When I tried to configure Php 5.1.6, I received the error: configure: error: Cannot find MySQL header files under /usr/local/src/php-5.1.6/ext/mysql. Note that the MySQL client library is not bundled anymore! i don't know enough about linux to know what is wrong. Can anyone provide help?
View Replies !
ERROR 1045 :: LAMP On Ubuntu
I have installed LAMP on an ubuntu machine. Now when I use the command: mysql -u memyid -p it gives me this error: ERROR 1045 (28000): Access denied for user 'memyid'@'localhost' (using password: YES) I did input the password that I set when installing the lamp package. But I do not know why it is acting this way... could some one tell me where I'm going wrong?
View Replies !
Odbc Problem While Hosting Mysql In Ubuntu
I am new comer in mysql, i have a code that is running well when i am using vb6 to accessing mysql database which is hosted in windows. But the odbc facing problem ( table "ttt" does'nt exist ) when i am trying to host the mysql database in ubuntu. I have trying to looking for the solution from google, but until the time of writing this thread, i got no solution.
View Replies !
Restoring Backups From WindowsXP To Linux Ubuntu
I have MySQL tables on a WindowsXP box and backed them up then tried to restore them onto a Linux box. However, it doesn't seem to work. I can find no trace of the restored files (there are no errors) on the Linux box even though the restore process displays as if it's taking place normally and successfully Any suggestions?
View Replies !
Can't Edit A Stored Procedure/procedure Already Exists
mySQL server: 5.0.24A client: Administrator: 1.2.3rc It's a clean installation with no other versions of mySQL I have no problems to create and run a stored procedure, but when i edit the stored procedure i get the error "MySQL error number 1304 PROCEDURE xxx already exists" Anyone know what i am doing wrong?
View Replies !
Post New Record
I have a table with orders, and i'm using the field OrderID (auto_increment) to store an ID for each order. (every new order, gets an ID +1 of previous). I use a php script to register the orders, and here is the big problem: I want the OrderID of the new order record to be shown to the user, right after he posted the order. Basicly, i want to know what value the OrderID (auto increment) will get. I assume theres no function to predict that, but are there any functions that will bring me the ID value as soon as the record is added?
View Replies !
Post Counters
I am new here. Stumbled along the forum whilst trying to find a help file in regards to Post Counters for my Forum. I was looking for statistics on my Highest Poster for the month and also highest New-member Poster for the month was. Am hoping that this kind of information is available through the MySQL somewhere.
View Replies !
Order By :: Last Post
I have a "news" database and I only want to get out the last post, not the whole database. idnews headline date content I use the following: $sql = "Select * from news order by idnews desc"; Anyone know a command to only get the last post?
View Replies !
Selecting The First And Last Post
So each query will be: - Fetch thread details - Fetch first post details - Fetch first post users username - Fetch Forum the threads in - Fetch last post details - Fetch last post users username Where the forum has no access requirements or the user has the user data for it. My current query;...
View Replies !
How To Use A Copy Of A MYSQL 4.1 Database In MYSQL 5 Running On Ubuntu Linux
We had a "permanent world" game server running on an older PC, under Ubuntu 5.10, using a MYSQL 4.1 database to store persistent data for the players, then the hard disk quit. We did back up our data on a regular basis, but didn't use MYSQL to do the backups, we simply copied the MYSQL/data/ folder to disk. So now we have a new hard disk, with Ubuntu 7.10 and MYSQL 5 installed. We have everything working, in that we have created the appropriate database and, using a simple test module of our game which will create some of the tables if they don't exist in the database, we can store and retrieve data from the database tables. The problem we have is how in the world do we get the data from the backup copy of the MYSQL 4.1 created database into the new MYSQL 5 database correctly? With 4.1 we could copy the contents of the database folder right into the database folder in the /var/lib/MYSQL/ folder, but this procedure didn't work with MYSQL 5. The files seemed to copy, as in the copy operation gave no errors, but we get an error that says the database is unavailable and to make sure the MYSQL server is running - it is, so we're stumped, and our game server is offline.
View Replies !
Post Install Of 4.0 Complications
I just installed mySql 4.0.14-0 onto my redhat 9.0 based laptop. Everything works fine except that there are ten copies of mysqld running. I have removed the /etc/my.cnf file, changed the file, restored the file and nothing changes the number of daemons running. Another guy I worked with installed the same rpms from Mysql.org and ther is only one daemon running.
View Replies !
POST Submit And MySQL
Probably something stupid, but I don't get this.. When I put a value in the database I first use addslashes (PHP): $lastname = addslashes($lastname); In my MySQL database I see this for example: D'Hoore When I do a search on D'Hoore through a POST form and echo the value submitted I get this: D'Hoore But when I do a SELECT * FROM contact WHERE lastname LIKE '%$lastname%'; it doesn't return anything!Should I use addslashes() on the search term? Stripslashes? Nothing seems to work?
View Replies !
Table Name From Post Variable.
Why doesn't this work - I can't figure it out. $txt1 = $_POST[Title]; $sql2 = "CREATE TABLE $txt1 ( ThreadTitle varchar(9999), Date varchar(12), Username varchar(12) )"; mysql_query($sql2,$con); echo "Your Forum Was Successfully Created. Please Return <a href='index.php'>Here</a>."; mysql_close($con); ?>
View Replies !
Viewing Post Trends
What are some techniques for viewing long-term trends of posted data? i.e. In a forum, what would be one way to examine how many posts have been made each day for the past month? Assume a data structure similar to this: table_posts ----------- post_id - unique integer id post_time - integer unix timestamp of the time the post was made message_title ...
View Replies !
Select Tags With Post
I have 2 tables in my database, one for posts and one for tags, and i want to get all the tags for each post, in the same query calling for the posts. here is a simplified version of my structure: table 1 'posts' ============================= post_id post_title post_text table 2 'tags' ============================= tag_id post_id tag_title tag_text I want to write a query that will list the posts, and for each post, will get all the associated tags, sorted by tag_title=tag_text Is this even possible? Currently each post makes about 6 queries to the database bacause of the tags and their use in different places, so if I can get all this into one query, it'd be awesome.
View Replies !
How Do I Post My Tables For Viewing Via My Website?
I can view all my tables on my server/host site, but can't figure out how to post the table I want to be able to view and enter data into via my website. My website under "my admin" feature was set up to let me enter a persons username, password and email address. However, I can only view "username" on my website under admin. I want to be able to add new data, like the date to my website so that I can enter the date and view it on my website. Do I need to add php or html code to my existing webpage that lets me view my database?
View Replies !
Radio Button Values Won't Post To SQL DB
I have a form with radio buttons. I typically don't use them and thought I would take the time to figure them out this time. The values won't post to the database. Please let me know what I'm doing wrong here. The joint field is a yes/no question with 2 radio buttons: Code:
View Replies !
POST Method And Empty Fields
I am using the POST method and Update to edit my database records with an HTML form. I can successfully update the fields I want, but I don't always want to update all fields. However, when the form is sent the empty fields are updated with a value of zero. How can I 'ignore' the empty fields so I can just simply edit or update the fields I want to?
View Replies !
Post Stats For Every File Looked Up?
I have 909,000 plus files in my database. Is it possible to post the amount of look ups , stats, for every file looked up? Example: People searching my database via my web site. If 700 people looked at a file, while viewing that file, it also tells you 700 look ups as part of the results? Code:
View Replies !
Getting Blog Post And Comment Count In One Query
I have a simple table named 'posts' that holds blog post and comment information. The columns are: post_id, post_title, post_content, post_parent_id All top level posts have a 'post_parent_id' of zero, and all comments have a 'post_parent_id' that matches another row's post_id in the same table. I've been trying to write a single query which returns all top level posts as well as the number of comments related to that post. I thought it would be simple, but I've been working on this WAY to long and finally am asking for assistance. This is the closest I've gotten, but it doesn't work... SELECT post_id, post_title, post_date, post_content, (SELECT COUNT(*) FROM posts WHERE post_parent_id=post_id) AS comment_count FROM posts WHERE post_parent_id=0 ORDER BY post_date DESC;
View Replies !
POST Fields From Dynamic Table List
Scenario: I'm connecting to "points" table in a Records posting form. SELECT pointCode, pointamt, pointcount, amt_type FROM points Now I do the select list and tell it to only display "pointName" in the form So far so good. Then I get lost lol. I don't know where to go from here to get those values of the pointCode, pointamt, pointcount, and amt_type set up for POST once the user has made their selection. I'm thinking they are locked up nice and snug in my $row var but not sure and if so, how do I get them OUT?
View Replies !
How Do I Change The Date Of A Post On My Forum Site?
Hi, I have started a forum site with a couple of friends. The forum runs on xoops using php 4 with a mysql (4) database. I accidently deleted a few posts. No problem there because I had a copy of the text and posted it again. But the problem is the date and time - obviously it shows the date of the new post and not the date of the deleted one. As I am a newbie still experimenting with mysql and php, I'd sure appreciate your help. Summary: ======= I need to change the date of a post in the mysql database. I access the database using phpmyadmin.
View Replies !
Bulk Delete WP Post Via Mysql Query
I want to delete posts that I have made in a particular category in WP [more than 2000+] How can I delete all the post from a particular cateogy[Uncategorized] via a MYSql query. What query do I need to run?
View Replies !
Keeping Track Of Post Views Every Day (Table Structure)
I was thinking of having a table to keep track of post count every day. For example, i have the following table structure: CREATE TABLE `wp_views` ( `post_id` bigint(20) NOT NULL, `year` tinyint(4) NOT NULL, `month` tinyint(2) NOT NULL, `month_hits` int(7) NOT NULL default Ɔ', `day_1` int(6) NOT NULL default Ɔ', `day_2` int(6) NOT NULL default Ɔ', `day_3` int(6) NOT NULL default Ɔ', `day_4` int(6) NOT NULL default Ɔ', `day_5` int(6) NOT NULL default Ɔ', `day_6` int(6) NOT NULL default Ɔ', `day_7` int(6) NOT NULL default Ɔ', `day_8` int(6) NOT NULL default Ɔ', `day_9` int(6) NOT NULL default Ɔ', `day_10` int(6) NOT NULL default Ɔ', `day_11` int(6) NOT NULL default Ɔ', `day_12` int(6) NOT NULL default Ɔ', `day_13` int(6) NOT NULL default Ɔ', `day_14` int(6) NOT NULL default Ɔ', `day_15` int(6) NOT NULL default Ɔ', `day_16` int(6) NOT NULL default Ɔ', `day_17` int(6) NOT NULL default Ɔ', `day_18` int(6) NOT NULL default Ɔ', `day_19` int(6) NOT NULL default Ɔ', `day_20` int(6) NOT NULL default Ɔ', `day_21` int(6) NOT NULL default Ɔ', `day_22` int(6) NOT NULL default Ɔ', `day_23` int(6) NOT NULL default Ɔ', `day_24` int(6) NOT NULL default Ɔ', `day_25` int(6) NOT NULL default Ɔ', `day_26` int(6) NOT NULL default Ɔ', `day_27` int(6) NOT NULL default Ɔ', `day_28` int(6) NOT NULL default Ɔ', `day_29` int(6) NOT NULL default Ɔ', `day_30` int(6) NOT NULL default Ɔ', `day_31` int(6) NOT NULL default Ɔ', UNIQUE KEY `post_id` (`post_id`), UNIQUE KEY `year` (`year`), UNIQUE KEY `month` (`month`) ) Let say, today is the 20th July 2007, so my insert query will be like INSERT INTO wp_views (post_id, year, month, month_hits) VALUES (1, 2007, 7, 1) ON DUPLICATE KEY UPDATE month_hits += 1, day_20 +=1; Is my table structure alright? or is there a more efficient way of doing this?
View Replies !
Using TCP/IP Instead Of Unix Sockets
An associate has asked me to take a look a problem he's having with starting mysql. I thought I'd give it a shot to learn some more about mySQL before having him turn it over to someone more knowledgeable than I. But I have to ask here first. Attempting to connect to the database via mysqladmin or mysql results in the error (paraphrased) "Cannot connect to local database using socket "/var/lib/mysql/mysql.sock". That is the path to the socked specifiet in both mysqld and client sections of the my.cnf. mysqladmin -h `hostname` version shows that the Connection is via TCP/IP rather than Unix Sockets. Running on Redhat Linux AE 3 (I think) /var/lib/mysql is world-writable-readable, but it is not owned by user mysql (my next attempt to fix this) /var/lib/mysql/mysql.sock is 777. My question: What would be causing mysqld to be using TCP rather than Unix sockets? I've checked permissions, verified settings in my.cnf (which is very sparse... other entries are for logging), confirmed mysqld is running and accessible via TCP/IP.
View Replies !
Unix Date Problems
1) I was investigating the unix_timestamp routine in mysql (version 3.23.46-nt) and for some reason the unix epoch (1-1-1970) was returned with a value of -3600. Then, as you can see, it suddenly corrected itself. I can't replicate this error, but it caused me to shudder. Attached is the output from the command line client. 2) The function from_unixtime(n) wraps on my server after 2^31 seconds. e.g. select from_unixtime(2147483648) returns "1900-01-00 00:00:00". I suspect this is caused by the underlying time_t size that mysql was compiled with. Is this so? Are any versions of mysql compiled with a larger time_t? +---------------------------+ | from_unixtime(2147483648) | +---------------------------+ | 1900-01-00 00:00:00 | +---------------------------+ 1 row in set (0.00 sec) mysql> select unix_timestamp(); +------------------+ | u................................
View Replies !
Using CURDATE With UNIX Timestamp
I have a table where the dates are stored in UNIX timestamp format. I'm trying to use the CURDATE term for a select query but it isn't working. Does CURDATE work with the UNIX time stamp? Any help is appreciated. here's the query: select first_name, last_name, date_expires, title from cl_member, `user`, cl_chapter where cl_member.user_id=`user`.user_id and cl_member.chapter_id=cl_chapter.chapter_id and cl_member.chapter_id=14 and month(date_expires)=month(CURDATE()) ORDER BY last_name
View Replies !
Unix Socket Vs TCP Mode
Our mysql database always run smoothness, but there have a strange question always happy. We retrieve content using unix socket mode is always Correct, using TCP mode sometime will meet no return Error. What's wrong with TCP mode? For example, We need to retrieve content from table Tab_Memo, the condition with ‘large’ is over 20KB, with ‘small’ is about ‘5KB’. Using unix socket mode: ---------------------------------- mysql -u root -p password 1、select * from Tab_Memo where name = ‘large’; // The result is Correct. 2、select * from Tab_Memo where name = ‘small’; //The result is Correct. Using unix socket mode ---------------------------------- 1、select * from Tab_Memo where name = ‘large’; // NO result return. 2、select * from Tab_Memo where name = ‘small’; //The result is Correct.
View Replies !
TimeStamps In Unix-Format
In my database i have to work with timestamps in unix-format like '20070101000000' for 2007-01-01 00:00:00. Now i have to look for the summary of the difference of two timestamps. The single difference of the timestamps are between one minute and about 15 hours. Now i don't know how to manage the correct sumary that should give me how many days, minutes and so on are summed.
View Replies !
Two Versions Of Mysql On Same Unix Box
I have mysql 3.23.58 version running on my unix box. I installed a new application on it which need mysql version > 4.0 so I thought of having two mysql versions running on the same unix box. I have first installation in /usr/local/mysql and I untared the new version in /var/local/mysql-standard-4.1.18-pc-linux-gnu-i686-glibc23. I am following instructions given in http://dev.mysql.com/doc/refman/4.1/en/multiple-servers.html I also created a empty file and named it as mysql.sock.new and stored it in /var/local. When I try to start this new version from /var/local/mysql-standard-4.1.18-pc-linux-gnu-i686-glibc23 using ./bin/mysqld_safe --datadir=/var/local/mysql-standard-4.1.18-pc-linux-gnu-i686-glibc23/data & it says "A mysqld process already exists". Please tell me where I am going wrong and how to configure it properly?
View Replies !
Selecting By Unix Date
I'm trying to do a very simple thing: I have in my DB a row called at_date, in it I enter a 10 digits number of date, like: 1171869716. How can I select all the data from the table where the month is the current month (and year of course), or any month I choose? Better saving the dates in a different format?
View Replies !
Covert Unix Timestamp
Been trying to use DATE_FORMAT on a timestamp in my table. However, just noticed that it's a UNIX timestamp, and not a datetime() timestamp. Is there a function that convert unix timestamps in a sql statement? Trying to get the format "dd/mm/yyyy"
View Replies !
Unix Timestamp Select Query
I am having trouble with the following sql query.I am trying to select all records in the future where the date is greater than today but to include today, the date field in the db is an unix timestamp. Code: "SELECT * FROM mysqltable WHERE mysqldatefield > now()-1 ORDER BY mysqldatefield DESC"
View Replies !
MySQL Generate UNIX Timestamp
Cam MySQL create a UNIX timestamp during an INSERT? I want to create a timestamp that is the number of seconds since January 1st 1970. Are there any inbuilt functions for doing so?
View Replies !
GUI Interface For Unix Linux And Solaris Etc.
Is there a GUI Interface for MySQL ... that runs on Unix (Solaris, Linux, etc) There was an earlier thread about it - http://forums.devshed.com/showthread.php?t=51564&page=1&pp=15&highlight=GUI but most of these seem to run on Windows only.
View Replies !
Inserting Current Unix Timestamp
I am working on coding a query to generate a phpBB useraccount in the mySQL database. INSERT INTO kylebt_Forums.phpbb_users SET `username` = '%username%', `user_password`=MD5('%password%'), `user_email`='%email%', `user_regdate`='' The user_regdate field is giving me problems as far as accepting the 10-digit unix_timestamp(); Apparently phpBB reads the PHP command time() however I am not sure how I need to implement this in the above code to have the timestamp show up correctly in the mySQL table. Currently, the user_regdate is showing up as the default value of '0'
View Replies !
Table Names On Windows/Unix
My development machine is Windows, while the production machine is Unix. I'll create a table on the Windows machine called "ABCD". I'll name it the same on the Unix machine. However, for some reason, the Windows mysql will rename it to "abcd", I assume because Windows is case insensitive. Of course, when I deploy the app to Unix, it crashes until I go through all my code and rename all database references and xml to "ABCD". Is there a way, on Windows, to make sure it calls the table "ABCD", so when I use my IDE's, it brings the tables in with the proper name?
View Replies !
|
TRACKER
