[TYPO3] How to Replace Database

[robin niemeyer]

Hi Nate,

I think you want to setup a new local copy of your live environment? If 
that's the case, you would run into trouble if you only do a DB update, 
since your live DB may have been altered by extensions you haven't 
installed in your testing environment.

The best way to get both environment in sync would be (besides the DB 
dump you actually made) to replace the fileadmin, uploads and typo3conf 
folders in your local environment with the ones from your server.

For the DB export/import stuff you can either do a 'mysqlimport' (see 
the MySQL manual for more info) or, more convienient, use phpmyadmin 
(see http://www.phpmyadmin.net/home_page/index.php), which you could 
also install as an Typo3 extension.

Just read your follow-up:
> and the sql file I'm trying to import is 
>   390MB.

The max. import size for a MySQL dump with phpmyadmin is around 10 MB, 
but there is a similar tool called HeidiSQL, which could handle much 
larger dumps, but I don't know if this works for Mac OS. Maybe you can 
take a look at the graphical tools provided by MySQL: 
http://dev.mysql.com/downloads/gui-tools/5.0.html

On the other hand, you could also do a dump on a per table basis, so you 
have smaller files.

One last possibility would be to edit the dump files manually, i.e. to 
cut some of the data, since you won't need every single content you have 
in your life environment.

Cheers,
Robin

Nate Russell schrieb:
> Hello
> 
> I'm sure this is easy for the more experienced but I need help replacing 
> a database. About a year ago I set up a copy of my website on my local 
> machine so I can experiment with a few things. After a few false starts 
> I finally got it up and running. Now I would like to replace the local 
> database with a copy of my recent backup from the live server.
> 
> Doing this with the initial install tool was easy enough but I'm having 
> problems doing this with the Database Analyser.
> 
> What is the proper way of doing this?
> 
> Thanks in advance,
> Nate
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>