[TomBarrand]

In SQL Server the full database that I am transferring to MySQL is 85GB. I have transferred all of the tables from SQL Server to MySQL apart from the Attachments table and they take up 2GB of space so the Attachments table must be over 80GB.

Is it possible for MySQL to hold that much data in one table?

Cheers

[TomBarrand]

Hi,

I have used a template my.cnf file and this got rid of the error, but has given me another error now.

When I had the problem before it would always stop on the record 5389 then I would get the max_allowed_packet error. After changing this value to 1GB the error went and approximately 70,000 records were imported then I got the error “The table 'Attachments' is full.

Any ideas? Is there some setting for the maximum table size?

The SQL Server table that I have has 1.2 million records in it.

Thanks

[TomBarrand]

I will try one of the templates and see what happens.

I can't use MySQL Administrator to do it because it won't run on the version of Linux that I am using. I am using an IBM Open Power 64bit server and the tool won't run on it, so I have to connect remotely, but you can touch the startup variables remotely.

Will let you know how I get on.

Any ideas how I will know if it has worked? Is there a command to type to tell you what the variable is currently set to?

Thabks

[TomBarrand]

Hi,

I don't seem to have the file. I have looked in all of the folders in the MySQL install directory and also /etc and there is no my.cnf.

I have noticed that there are some sample files, medium, small, etc. Could I just copy one of thesr to /etc and rename it to my.conf? How do I determine which sample to use?

Thanks for your help

[TomBarrand]

Hi,

I have looked at that article and tried what it says, but I still get the same problem.

I am running the following version of MySQL.

Linux (IBM/Motorola PowerPC, IBM/POWER) Standard 4.1.10a

This is how the commands looked when I typed them in on the server:

mysql -> mysql –max_allowed_packet=1GB

-> mysqld –max_allowed_packet=1GB

->

It doesn't look like they have taken effect. Is there something I am doing wrong?

I have a table with hundreds of thousands of rows in in and one of the fields is holding a binary document. It is crucial that I can use your tool to migrate this table from SQL Server to MySQL.

Thanks for your help

Tom

[TomBarrand]

Hi,

I am using the ODBC Import to take data from an SQL Server database to a MySQL database. It works fine apart from one thing.

I have a large table in the SQL Server database that stores documents as Image datatypes. SQLYog creates the table and gives the column a longblob datatype. It imports 5389 rows then stops with an error:

Got a packet bigger than 'max_allowed_packet' bytes.

How do I get round this? I really need to get this working.

Thanks for your help

[Author]

Posts