Technology Tools for Ministry

Community

Web-Empowered Church User Community
All Categories > Getting Started > Using TYPO3 > sql import limitation in site transfer
Total Posts: 3 - Pages (1): [1]
user picture Author: Andre Daley
Posted: Jun 18 2008 - 06:45 PM
Subject: sql import limitation in site transfer
I am trying to transfer our site to a new host. I have followed the how to instruction and tried to import the sql file using phpadmin. After about a half hour I got an import error suggesting the file was too big. the file is 40,167 kb and the import limit is 10,000 kb
How do I get around this? Any help is appreciated

Andre
user picture Author: Mark Stephenson
Posted: Jun 18 2008 - 07:30 PM
Subject: re: sql import limitation in site transfer
Andre,

When this has happened to me, I carefully grabbed small sections of the SQL file and pasted them in one at a time. You can also request more memory from your hosting company.

In Him,
Mark
user picture Author: Calum MacLeod
Posted: Jun 19 2008 - 10:13 AM
Subject: re: sql import limitation in site transfer
yahoo msn
Calum's Suggestion
Using phpmyadmin, note the total number of tables in your typo3 database. Select a fifth of these at a time and export as an SQL file. Once you have saved all five fifths, then use phpmyadmin to import. Although this method takes five times longer than transferring the entire database, it should not break the 10K barrier
Total Posts: 3 - Pages (1): [1]
Click here for a complete list of threads
You must login to post a message to this conference.