[x] Navigation

[x] Wer ist wo
 Bots:
1: Google > Nachrichten
2: Yahoo > Forum 9.x
3: Wget > Forum 9.x
 Visitors:
1: Forum 9.x
2: Forum 9.x

[x] Languages

[x] Design
Each user can view the site with a different theme.
Themes marked with a * also change the forum look.

[x] Downloads (Top)
MySQL Backups
Forum FAQForum FAQ   SearchSearch   Log in to check your private messagesLog in to check your private messages   LoginLogin
Post new topic   Reply to topic   Printer Friendly Page    Forum Index > > HowTo & Allgemeine Fragen

View previous topic :: View next topic  
Author Message
lexi_
Doppel-Null-Agent


Joined: Jul 07, 2004
Posts: 178
PostPost subject: MySQL Backups
Posted: 26.11.2006 18:13		 Reply with quote
ziehe mein Backups mit sqldump und spiele es per Shell auch wieder zurück leider werden die Backups in der falschen Sprachkodierung erstellt wie bekomme ich die in uf8 hin und wieder als uft8 wieder zurückgespielt
mfg
lexi

lexi_'s Serverdaten - verwendete Vers. (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Server SUSE 9.3 / PHP 4.3.10 / Mysql 4.1.10a / cpg 9.2.0.RC2
Back to top
View user's profile Send e-mail
Ertan
Webmaster


Joined: Mar 19, 2004
Posts: 1220
Location: Germany
PostPost subject: Re: MySQL Backups
Posted: 27.11.2006 16:50		 Reply with quote
iconv -f iso-8859-15 -t utf-8 alte.sql > neueutf8.sql Wink

oder gleich "--default-character-set=utf8" verwenden
_________________
.: USE THE FORCE :.
Helft mit ! Keine Unbeantworteten Beiträge mehr

Ertan's Serverdaten - verwendete Vers. (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Send e-mail Visit poster's website Photo Gallery
lexi_
Doppel-Null-Agent


Joined: Jul 07, 2004
Posts: 178
PostPost subject: Re: MySQL Backups
Posted: 27.11.2006 20:02		 Reply with quote
Ertan wrote:


oder gleich "--default-character-set=utf8" verwenden
wo schreib ich das rein und wie
mfg
lexi

lexi_'s Serverdaten - verwendete Vers. (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Server SUSE 9.3 / PHP 4.3.10 / Mysql 4.1.10a / cpg 9.2.0.RC2
Back to top
View user's profile Send e-mail
Display posts from previous:   
Post new topic   Reply to topic   Printer Friendly Page    Forum Index > > HowTo & Allgemeine Fragen
Page 1 of 1
All times are GMT + 1 Hour



Jump to:  


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum




Interactive software released under GNU GPL, Code Credits, Privacy Policy