Import a SQL dump

[DKasemier]

I made a SQL dump with PHPMYADMIN and with VB2, but.. when i try to import, tables appair all over my phpmyadmin and the vB i use is screwed up :'(

[JamesUS]

phpMyAdmin has problems exporting the vB templates.
You need to either remove the templates from the dump file or dump using telnet.
There might be a way to fix it but I don't know it if there is

[George L]

really someone should really look at fixing this phpmyadmin import problem for vb dumps - has anyone actually posted a fix ?

[DKasemier]

Originally posted by eva2000
really someone should really look at fixing this phpmyadmin import problem for vb dumps - has anyone actually posted a fix ?

\

so its normal? i was afraid of that

[MovieJeff]

You mean there is no way to backup the forum and then re-install it if there is ever a problem or server move?

I want to be able to back up all the forum, dnload it to my local computer here, then be able to re-upload it without loosing anything (i.e. basically a full system backup). Can this be done or are there problems with this?

Thanks.

Jeff

[George L]

Originally posted by MovieJeff
You mean there is no way to backup the forum and then re-install it if there is ever a problem or server move?

I want to be able to back up all the forum, dnload it to my local computer here, then be able to re-upload it without loosing anything (i.e. basically a full system backup). Can this be done or are there problems with this?

Thanks.

Jeff

well yes you can if you have root telnet access otherwise you can backup the forum database and have your web host do the import back

any good web host would have no problem reimporting a database for you - it takes less than 10 - 20 mins to anyway

[DKasemier]

Originally posted by DKasemier
\

so its normal? i was afraid of that

you only can't do it with phpmyadmin

[El_Muerte]

the problem is that importing takes longer then dumping, importing the whole database exceeds the maximum execution time. Either set the time higher, or use the MySQL commandline utility to import it. Breaking the dump file in smaller files may work.

[JamesUS]

Actually the problem is with phpMyAdmin not escaping the templates properly.

[DKasemier]

Originally posted by El_Muerte
the problem is that importing takes longer then dumping, importing the whole database exceeds the maximum execution time. Either set the time higher, or use the MySQL commandline utility to import it. Breaking the dump file in smaller files may work.

indeed it's NOT executing time, information is parsed because there is very much scripting in the TEMPLATES, phpmyadmin isnt build for templates

[Synchro]

Whats the latest on this as I am trying to do it at the moment?

[Steve Machol]

This thread is over 3 years old. I suggest starting a new thread with all the relevant details about your problem.

[Erwin]

The safest thing I've found (after moving my database to over 10 servers) is to copy directly the mysql files, and just chown them to mysql after a transfer using scp or rsync. Guaranteed to problems, since there is no exporting or importing.