• Import Microsoft Access database into MySQL

    I'm currently on a Windows machine with a Microsoft Access database. I need to import that into MySQL on another Linux web server. Here's what I'm doing right now: Exported as text file Copied with FTP Loaded into MySQL Is there a better process for this? Any help would be appreciated.

    ITKE1,042,755 pointsBadges:
  • How to check if a table exists in MySQL server

    Hi, To connect to my MySQL server, I've been using an ODBC connection. Is there a way to check if a table exists in my database? And if it's not there, how can I create one?

    ITKE1,042,755 pointsBadges:
  • How can I escape all CRLF chars in all column values when doing a select?

    Let's say I want to do: SELECT * FROM tableName But some columns' values have linebreaks, so in my MySQL console it breaks the formatting of the table. I know I can circumvent this by explicitly REPLACE()ing CLRF chars, but this requires me naming each column and is not very quick to type out, eg.:...

    hazzlewis5 pointsBadges:
  • Storing PDF files in MySQL as BLOBs

    Experts, Can you please help me? I need to store several PDF files into MySQL as BLOBs. How can I do that using PHP? You are the best!

    ITKE1,042,755 pointsBadges:
  • How can I load CSV files into MySQL Workbench?

    I have several CSV files that need to be added into my database in MySQL Workbench. Is there a way to load them in? Is there a specific command I should use? Any help is appreciated.

    ITKE1,042,755 pointsBadges:
  • Is MySQL table supports both foreign keys and partitions?

    I have one table like employee (emp_no,emp_name,dept_id). This table contains the foreign key relation with deportment table (dept_id). Now I want to do partition on emp_no field in employee table. Is it possible or not?

    lakshmilogica15 pointsBadges:
  • How to show progress of CSV file to MySQL upload

    My CSV file is very large (Millions of files) and I'm currently loading it into MySQL. I'm using the LOAD DATA INFILE command. But I feel that this is taking way too long. Is there a way for me to see the progress of the upload? I tried SELECT COUNT(*) but it keeps giving me a 0 count. What should...

    ITKE1,042,755 pointsBadges:
  • Export/Import database with large blobs in MySQL

    Hi, we are having trouble exporting and importing databases with blobs in mysql. We have a development environment and a production environment both running mysql-5.0.45 and want to dump databases with blobs from one to the other. We have tried with many options but nothing works. When importing...

    jailall101785 pointsBadges:
  • Data synchronization/integration between two web applications

    Real time synchronization of two web applications is required. The scenario is that there is an E-commerce website which will display a super market products on its website plus E-commerce website has its own products too. The super market's  inventory management system will be in real  time...

    maha1235 pointsBadges:
  • Upload image from Excel sheet into MySQL

    How can I upload image from my Excel sheet to MySQL Database?

    BatulBohra5 pointsBadges:
  • MySQL 5.7 database: Table has crashed and last repair failed

    I have MySQL database, but two days ago, I stumbled upon an issue - Table is crashed and last repair failed. I don't know how to solve this issue. I need to get MySQL recovery tool.

    heraturs15 pointsBadges:
  • MySQL: Look for top 3 in each group

    I know this has been discussed MANY MANY times, but I've used all the previous answers and still have issues. In my table we have to look for top 3 in each group and show ties. So if there is a tie it should return more than 3 rows. I have a working MS Access query, but MySQL doesn't use TOP and...

    DanielKYantis5 pointsBadges:
  • New to php/mySQL having an issue with Mac OSX

    I'm following the lynda.com video series on php with mySQL and have run into a hangup. When I install mysql and I'm checking to make sure it's all running, pointing a browser to http://localhost gives me the apache is running page, but going to http://localhost/~(myusername)/, I get an error saying...

    Kjtriplett15 pointsBadges:
  • Check to see if MySQL table field exists

    Would it be possible for me to check to see if a specific index exists on a MySQL table field? What command do I have to use?

    ITKE1,042,755 pointsBadges:
  • Convert CSV file to MySQL table

    How can I convert my CSV file to my MySQL table? Furthermore - the first row of my data needs to be used as the column names. Thank you so much.

    ITKE1,042,755 pointsBadges:
  • Can I connect JavaScript to MySQL?

    My apologizes if my question appears short but it's to the point. Would I be able to connect JavaScript with MySQL? If not, is there some sort of work around?

    ITKE1,042,755 pointsBadges:
  • How can I save a PHP array to a MySQL field?

    How can I save a PHP array to a MySQL field? And, once that is done, would it be possible to get it in array form? Thanks for all the help.

    ITKE1,042,755 pointsBadges:
  • Deleting all records from MySQL table using phpMyAdmin

    I'm currently using a WAMP server. When I'm trying to delete all of my records in a MySQL table using phpMyAdmin, it keeps deleting only one record at a time. I need to delete all the records. How can I do that?

    ITKE1,042,755 pointsBadges:
  • Halt running MySQL query

    Each day, I usually connect to MySQL from a Linux shell. Every once in a while, by accident, I run a query that's way to big and I have to stop it. When I tried Ctrl+C - it stopped all of MySQL and I have to reconnect. Can I just kill this one specific query? Thank you so much.

    ITKE1,042,755 pointsBadges:
  • Oracle In Linux

    How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

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

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

Following