| Subject | Date Asked |
|
| backing up and restoring mysql | 6/30/2009 |
Q: Beginner question for you Marty. I wanted to use mysqldump to backup MySQL databases from my Redhat ...
A: John, Looking at the discussion on http://littlelink.webtrouble.com/?WH5H I'm thinking that your ...
|
| MYSQL CLUSTER | 6/23/2009 |
Q: I am much impressed with your profile. Now i have one question I Need to configure a MYSQL cluster. ...
A: XAMPP will do this for you! http://littlelink.webtrouble.com/?ZLkd has the FAQ for Mysql using ...
|
| SQL Table with current date | 3/26/2009 |
Q: I am trying to create a table and I need one of the columns to be automatically filled with the ...
A: Luis, I got it to work by using quotes CREATE TABLE USERINPUT ( COMMENTS VARCHAR(200), DATEID DATE ...
|
| Large MySQL query | 2/19/2009 |
Q: Marty, I have an older MySQL database (3.23.52) which has been very stable running on Linux RedHat ...
A: Ray, Check out the stuff on http://acs.ucsd.edu/info/jobctrl.shtml especially the renice command at ...
|
| MySQL access denied 1045 | 2/17/2009 |
Q: Marty- This is a continuation of a past question that I did not get a chance to follow up on. Hope ...
A: I've used winamp too but haven't encountered this. Try logging onto Mysql as root from the console, ...
|
| phpmyadmin and password add | 2/16/2009 |
Q: Marty- I am about to upload my first database site and didn't realize till now that I never set a ...
A: Rich, I have always done this either through the cPanel Mysql screen which makes it easy, or from ...
|
| mysql is is free? | 2/12/2009 |
Q: i know that mysql is free, but i just want to clarify if it is free to use on our company. thank ...
A: Nhoel, Please see the solutions page on the Mysql website for the options - there are free and paid ...
|
| multiple insert | 1/20/2009 |
Q: "hi... good day... i would like to ask whats wrong with my query I tried to insert multiple record ...
A: Madzmar, Your question is quite long - I only read the beginning of it. According to the Mysql ...
|
| mysql and jdbc | 7/2/2008 |
Q: i am a new user of mysql. I am trying to connect my sql database with java program.But i am unable ...
A: Keerthi, Is there any more to the message than that? It sounds like when you import java.sql.* ...
|
| Query about mySql | 4/25/2008 |
Q: I want to store & retrieve the images in MySql. Is it possible? If Yes pls send me the procedure to ...
A: Sachin, You can use the blob MySQL data type, described at http://littlelink.webtrouble.com/?tQXc ...
|
| mysql drivers | 3/8/2008 |
Q: my question is how we know abt the driver means which to use? for ex..."com.mysql.jdbc.Driver" and ...
A: Tulsi, I found this download by googling http://dev.mysql.com/downloads/connector/j/3.1.html ...
|
| SQL Programming Help | 1/30/2008 |
Q: I was hoping you may be able to help me. I have a large amount of data and it is currently in CSV ...
A: Michael, 18 million numbers is a lot of data, and I can't promise you that Mysql will do the job ...
|
| auto inc field | 10/9/2007 |
Q: I am trying to write code in Delphi to write to an existing MySQL db. The table I wish to write to ...
A: Karen, I haven't used Delphi so may not be much help. My only thought is, could you try inserting a ...
|
| mysql | 8/11/2007 |
Q: i have a mysql database under WinXp, i want to connect to it remotly, but always get error - host ...
A: I haven't set this myself but think you'll need something like ODBC installed in order to make the ...
|
| Showing database content within a html table | 8/7/2007 |
Q: I used a simple script to display all the entries in the table "news" in my database. You can see ...
A: Try my open source application FormATable - link at bottom. It's written in Perl and uses an HTML ...
|
| php | 7/26/2007 |
Q: Ok, I just learn how to write a php scrip to get up a database. but know how do i setup a login and ...
A: The easiest way would be to use an open source product such as Drupal - http://drupal.org. If you ...
|
| Mysql Copying | 7/19/2007 |
Q: i'm doing a Mysql database app in vb.net with about 200 entries in the tables. When i'm trying to ...
A: Do you see your table name when going into the database and typing show tables; Are you making a ...
|
| mysql database - messenger | 7/19/2007 |
Q: I'm building a database using C# (Visual Studio) I'm using MySQL to store the data. I have created ...
A: The problem I foresee with your approach is that you can't easily predict the number of friends each ...
|
| 1:1 relationship between tables | 7/13/2007 |
Q: How can I create 1:1 relationship between 2 tables using MySQL. Following are my 2 tables. Create ...
A: If I understand the question then the answer is to insure that there is a customer row for every ...
|
| Mysql administrator | 6/24/2007 |
Q: I want to create a database using Mysql administrator tool. please tell me how to do it. when i open ...
A: If you can't connect then you're stuck! The only thing to do at this point imo is to check your ...
|
| ODBC Connection | 6/10/2007 |
Q: I am trying to connect to a MySQl database hosted by a hosting compay, I have downloaded the latest ...
A: Rob, If your hosting provider has PHPMyAdmin available to you then the connection info will be ...
|
| avg for count more than | 6/6/2007 |
Q: Here's my db structure StuNo StuName Department GrandMark sample record 100A Mandy ...
A: To get the number of students in each department you can use SELECT Department, COUNT(Department) ...
|
| indexing | 3/18/2007 |
Q: I have a query which sets all the 'lastmod' values from update_products equal to the 'lastmod' ...
A: I would think you'd need to look through every row of both tables to do this query, and that's why ...
|
| Question about sorting | 3/18/2007 |
Q: I am running a query using product ids like this: SELECT * FROM products WHERE product_id=510 OR ...
A: So you do create the sort key as a new column - only on a temp table. Makes sense. Maybe there's a ...
|
| Question about sorting | 3/17/2007 |
Q: I am running a query using product ids like this: SELECT * FROM products WHERE product_id=510 OR ...
A: I don't know that you can. If there was a sort key which you could put on the table then you could ...
|
| database questions | 3/1/2007 |
Q: OK, I want to start a website for private tutors and students. I need to have a database on the ...
A: Nick, If you're going to do it all yourself then you'll need some knowledge of a server programming ...
|
| mysql consuming too much disk space. | 2/28/2007 |
Q: I have come to notice that the /var directory is taking up over 70% of that part of the hard drive. ...
A: Shailender, I am not personally experienced with this, however a search got me to this article - ...
|
| Tricky mysql query | 2/16/2007 |
Q: i am making a application of buses.. Now i will show you some rows from my database: ROUTE|FROM ...
A: Miha, I think you should collect all rows as you show, and then process them to look for ...
|
| Cant find error in syntax | 2/16/2007 |
Q: I have this query: [query] DROP TABLE IF EXISTS linije; CREATE TABLE linije ( id INT( 23 ) ...
A: Miha, Since the error message pointed to your first create I ran it on my own Mysql console, using ...
|
| mysql count query | 2/16/2007 |
Q: it wouldnt reached to that number since the user would enter the data up to 26 or if it exceeds then ...
A: I'm confused about what needs to be done. If users can only choose from a dropdown between values ...
|
| SQL JOIN | 2/15/2007 |
Q: i have this query: [query] SELECT users.username, news.title, news.body, news.posted_by, ...
A: Miha, I believe you will have to qualify the '*' with the table name just as you would for ...
|
| mysql count query | 2/14/2007 |
Q: ..i really need your help here... in my query..im using the function count(*)...and i want the ...
A: Scarlett, What do you mean? Say you issue the query >select count(*) from employees where name ...
|
| Mysql and Foxpro | 10/22/2006 |
Q: Hope you're doing great. I'm joseph from the Philippines. I'm new to Mysql but have an idea about ...
A: Joseph, I am not familiar with Foxpro myself but think you'll need the right ODBC driver for your ...
|
| Running Multiple MYSQL Servers | 10/3/2006 |
Q: We own a site that is projected to have over 3,000 users within the next few months. Our site offers ...
A: Andrew, Honestly 3,000 users doesn't sound like alot. However I am not a systems tuning expert and ...
|
| mysql allocated disk space | 10/3/2006 |
Q: In mysql is there any command to get the disk space allocated to Database and currently how much it ...
A: Shyamal, use database_name; show table status; Write back if you need more info. -- Marty ...
|
| Lock/Unlock the user | 10/1/2006 |
Q: I have an user account in mysql name james. I want to Lock the user and after some time i want to ...
A: Deepu, I think it would be easiest, as root to change that user's password. mysqladmin -u root -h ...
|
| Mysql on Windows | 9/26/2006 |
Q: Kindly help me on the following issues. 1. I am using PHP - Mysqlmysql-4.0.12 - PWS - Windows98 ...
A: Thomas, A google on that error message got me to this BBS posting: ...
|
| database | 9/24/2006 |
Q: I was wondering if you can give me some suggestions in how to create a databae using microsoft ...
A: Sue, I am not an expert on Access interactions with MS Outlook. However if you are undertaking this ...
|
| mysql query | 9/21/2006 |
Q: sir, i have 3 tables, booking,bookingFcl,container select b.booking_id , ...
A: Geetha, Could you show me by example the result you'd like to get and then the result you are ...
|
