How to import Mysql older version

[Beata]

I want to import Mysql from old server and I am getting errors:

Fatal error: Allowed memory size of 41943040 bytes exhausted (tried to allocate 12515036 bytes) in /var/www/html/phpMyAdmin-3.3.10-all-languages/libraries/import.lib.php on line 290

My Mysql is quite large 1,85 MB
I have learn that it is possible to import splitted in pieces, but

anoter problem, I thing, I am getting errors anyway, because this is version 3.1.4

What to do. Is there some way to import?
Can somebody advice?

 

[mr.applesauce]

edit php.ini

 

[Beata]

Please explain in details

 

[Beata]

not every server aloow to access php.ini file
Where is php.ini in Joomla CMS?

 

[mr.applesauce]

ask your hosting provider

 

[Beata]

no help from free account

I have free account in Host1free.com and have no possibilities to post in forum or get answer from admin

P.S. Silly random questions are there to post message. No one answer I know eccept "fourth"

 

[zEitEr]

Devide you mysql dump into 3-5 parts, keeping mysql syntax, and import it part by part.

Note, you can export one-three tables from an old server and import it, after that again export two-free tables and import it into a new server.

Or, buy hosting with more RAM and resources.

 

[Beata]

I have imported first piece sussessfully - 6 tables
The second piece was very large - content - over 1000 rows and I got error. What it means ?


import.php: Missing parameter: import_type (FAQ 2.8)
import.php: Missing parameter: format (FAQ 2.8)

 

[zEitEr]

Devide it then...

 

[Beata]

But this is one table, I imagine - joomla content

 

[Beata]

Here it is about
import.php: Missing parameter: import_type (FAQ 2.8)


But I don't understand what I shoul do with it ?

2.8 I get "Missing parameters" errors, what can I do?

Here are a few points to check:

In config.inc.php, try to leave the $cfg['PmaAbsoluteUri'] directive empty. See also FAQ 4.7.
Maybe you have a broken PHP installation or you need to upgrade your Zend Optimizer. See http://bugs.php.net/bug.php?id=31134.
If you are using Hardened PHP with the ini directive varfilter.max_request_variables set to the default (200) or another low value, you could get this error if your table has a high number of columns. Adjust this setting accordingly. (Thanks to Klaus Dorninger for the hint).
In the php.ini directive arg_separator.input, a value of ";" will cause this error. Replace it with "&;".
If you are using Hardened-PHP, you might want to increase request limits.
The directory specified in the php.ini directive session.save_path does not exist or is read-only.

 

[zEitEr]

But this is one table, I imagine - joomla content

So what? You can export/import even one record from those 1000 rows. I don't see a problem.

 

[zEitEr]

But I don't understand what I shoul do with it ?

I guess, your one query is too long. Anyway you can not fix it, you should bypass.

 

[Beata]

Hi Alex,

I am doooooing piece by piece from line Insert to to next Insert to, - it is accepted and I don't believe that it will be everything successful

I am working already 3 hours, total have about 50 thous. rows

never did it

 

[zEitEr]

It's never too late to have the first time with it. Any way, row by row is too slow, 10-200 would be good choice. You can verify its size in a text editor. One INSERT shouldn't be too long, but you can have several INSERT`s in one time.

 

[Beata]

103412 rows inserted into MySql

EVERYTHING IS OK ! My site is alive and work

Thankyou Alex very much. If not you I am not sure that would do

My new website is http://genealogija.iwoly.com/

 

[zEitEr]

You're welcome