• MySQL Replication I think!

    Hi, I have a local Access Database that is the management system for a business. They now want to take some feature online so customers can do some functions themselves. What I am thinking is migrate the data to MySQL and use a local install of MySQL as the backend and point the Access front end at...

    Awestrope5 pointsBadges:
  • Running different versions of MySql on same machine?

    Is it possible to run different versions of MySql on the same server machine?

    Ozzyit25 pointsBadges:
  • Migrate MySQL database to SQL 2005

    We are looking to migrate from MySQL to a full blown iteration of SQL 2005. Are there tools in place that will allow us to migrate our data and tables or are we on our own for getting our data into the MS database?

    Karl Gechlik9,860 pointsBadges:
  • MySQL capabilities

    Do you guys know where Can I find specific details for MySQL like max number of records, max number of connections, max size of database etc etc? My version is Ver 14.12 Distrib 5.0.51a.

    Musoteflirt20 pointsBadges:
  • VB.NET development environment

    I am coming out of retirement and have a couple of projects I was going to do in VB 6. After doing a little research it became clear that I needed to migrate my development environment from VB 6/SP 6 to VB.NET. My question is very basic, what do I need to start VB.NET development? I do not have any...

    GlennSwett5 pointsBadges:
  • Photo upload in a profile with PHP and MySQL?

    Please help me by giving script for uploading and updating member photo in his profile using php and mysql

    Shreeuram45 pointsBadges:
  • Can I reference one field in MySQL?

    Here's what I have so far in MySQL: table1(a int,b int, primary key(a,b)); table b(e int,f int, foreign key(f)references table 1(a)on delete cascade) table b(y int,f int, foreign key(y)references table 1(a)on delete cascade)

    freetolearn5 pointsBadges:
  • What wiki software do you recommend?

    Just as the title suggests, what wiki software (DokuWiki, MediaWiki, etc...) do you suggest to run?  The purpose of this is nothing more than to make a remote note-taking sort of scenario, so it's not something for anyone but me to be used.  I know I could do my own thing and stuff, but I'd...

    Eric Hansen2,065 pointsBadges:
  • How to store an IP address in MySQL

    Could anybody tell me what the right field type would be for storing an IP address in MySQL? Also, what's the right way to store it too?

    ITKE352,565 pointsBadges:
  • Free online practice exercises on SQL/Oracle

    I would like to know is there any website which offers free practice exercises on SQL/Oracle queries? Preferably advanced level queries. Thanks, Kruti

    Kpatel0 pointsBadges:
  • How can I determine by database size in MySQL?

    Does anyone know if there's a specific query or function that can determine the size of my database in MySQL? If there isn't one, what's the best way to go about it? I tried this and it came up with 474989023196466.25 MB (even though I know the database is 400 MB). SELECT...

    ITKE352,565 pointsBadges:
  • How should I store large files in a MySQL database?

    We have a PHP script that we upload large files with (up to 500MB) and it's stored in a MySQL database. Here's the code we're using: mysql_query("INSERT INTO table VALUES('')"); $uploadedfile = fopen($_FILES['file']['tmp_name'], 'rb'); while (!feof($uploadedfile)) { $line =...

    ITKE352,565 pointsBadges:
  • How to I insert a table if it doesn’t exist in a MySQL database?

    In a MySQL database, I'm trying to do the following query: INSERT INTO table_listnames (name, address, tele) VALUES ('Rupert', 'Somewhere', '022') WHERE NOT EXISTS ( SELECT name FROM table_listnames WHERE name='value' ); But it keeps returning the same error. I don't want to insert a record if the...

    ITKE352,565 pointsBadges:
  • How can we check if a MySQL database exists?

    Can anyone tell me if it's possible to check if our MySQL database exists after we've made a connection? We already know how to check if a table exists in our database but now we need to see if the actual database exists. Thanks!

    ITKE352,565 pointsBadges:
  • Database Migration code in MySQL

    Code to migrate database in MySQL (tables, triggers, stored procedures, functions and views) to Oracle, MS Access & vice versa.

    akashi5 pointsBadges:
  • What’s the better database option: MySQL or SQLite?

    Our organization is deciding to use either SQLite and MySQL for our database. We understand that SQLite is a single-file database and MySQL is just a normal database. But in your opinion, what's the better option?

    ITKE352,565 pointsBadges:
  • How to export a MySQL database to SQLite

    I apologize for the short question but can anyone help me export my MySQL database into a SQLite database? Thanks so much!

    ITKE352,565 pointsBadges:
  • Multi-use of the database

    Hello. I've developed a local website using xampp, and I want to access the mysql database in it to develop a J2SE application. Is it possible? if so could you give me the right keywords to search since I kept trying every single word that could pop into my mind. Thank you very much.

    Hanai5 pointsBadges:
  • How to install the MySQL JDBC connector?

    Can anybody tell me how to install the MYSQL JDBC connector. I am getting error "java.sql.SQLException: No suitable driver ". I placed the driver in the java-jre\lib\ folder also in the shared folder of tomcat 5.0. Even in the lib folder of WEB-INF. But I am getting the same error.

    Advancedjava25 pointsBadges:
  • Migrating MySQL hosts

    We need to migrate a MySql database from one host to another. Will a simple backup and restore work? Are there references to the database inside itself? Will this work?

    NewnanIT1,110 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following