Need help importing into MySQL

J_Paul · #1 (**permalink**) 01-02-2008, 07:34 PM

Hi,

I'm having trouble importing into a database. The system we are updating only allows a 2m file to be imported.

I've pulled out the single table in the database and exported it, but it's 2.5 mgs. I've tried splitting it apart, but have had no luck.

Is there a way around this? I've also tried splitting the SQL file into two parts, import them as different table names, then try to combine them.. but have still had no luck.

Any help would be greatly appreciated.

Thanks,
John Paul

Tech Manager · #2 (**permalink**) 01-03-2008, 11:32 AM

John:

You didn't mention how you are trying to import the file. Are you doing a simple SQL query or a file import? There are several ways you import or add the data into a MySQL database.

I am not sure why you are splitting the data into two parts AND then trying to import as different table names. You could split the data and import into the same table.

Do all the relative tables in the database already exist?

Is this on a Linux or Windows box? Do you use PHP (what version?).

With a little more info I think I could help solve the issue for you.

J_Paul · #3 (**permalink**) 01-09-2008, 12:17 PM

The reason I split the database is because we are using MyPHPAdmin for the back in... It's a linux box.. and it's version 4 i believe of PHP.

It seems that it's cutting off every time there's a ; symbol in any of the text or HTML. The info in the database is all HTML code.

Thanks again fro your help.

Tech Manager · #4 (**permalink**) 01-09-2008, 12:56 PM

John:

I still don't see a reason for splitting the database. Without having a look at the data I suspect that it is improperly formatted to make the import successful. It doesn't sound to me that you exported it into a SQL format or else you are using an import method that does not allow for the escaping of special characters. Again, the above is just a guess without seeing the actual data.

J_Paul · #5 (**permalink**) 01-09-2008, 03:00 PM

Actually, I exported it into CVS files when I split it.

How should I go about importing it? If I use an SQL statement what would it be? phpMyadmin will allow me to do those, but i'm not very good with this sort of thing.

Are you familiar with phpMyAdmin?

Thanks again for your help.

Tech Manager · #6 (**permalink**) 01-09-2008, 03:20 PM

Yes, I am familiar with phpMyAdmin. It's a nice interface application.

Try Navicat it does a decent job of importing data from other formats into MySQL.

It's also fairly simple to write a short and sweet PHP script to go through your data line by line and insert it into the appropriate tables/fields.

J_Paul · #7 (**permalink**) 01-09-2008, 08:20 PM

Hey, I did the navicat thing... great program.. You are awesome tech manager..

After MANY trial and errors.. I set up BOTH databases in the program and just friggen copied the one table to the other database and bling bling it worked!!!!

Thank you so much for your help and time with this!!!!

Looks like we are gonna be buying this program.

John Paul

Tech Manager · #8 (**permalink**) 01-09-2008, 08:28 PM

Quote:

Originally Posted by J_Paul

Hey, I did the navicat thing... great program.. You are awesome tech manager..

After MANY trial and errors.. I set up BOTH databases in the program and just friggen copied the one table to the other database and bling bling it worked!!!!

Thank you so much for your help and time with this!!!!

Looks like we are gonna be buying this program.

John Paul

Glad I could be of assistance.

Good luck.