Support Forums

lowis · 09-09-2009, 05:21 PM

Hello somebody can help me I cant to download a backup from my database very well:
,
INSERT INTO `class_johnadmin` (`id`, `title`, `keywords`, `description`, `url`, `urls`, `email`, `notify`, `maximage`, `version`, `mainTemplate`, `mainIndexCols`, `mainCatCols`, `mainSubCols`, `mainTakeOffline`, `mainTakeOfflineReason`, `mainEmailValidation`, `smtp`, `smtpHost`, `smtpUsername`, `smtpPassword`, `smtpPort`, `mailHTML`, `htmlEditor`, `removeTime`, `showTotal`, `adminTemplate`, `template_title`, `template_logo`) VALUES
(1, '123rea.se Sveriges systemannonser', '123,123rea,123rea.se,sälja,köp,byta,hyr,hitta artikel på 123rea.se,TV-spel,Ljud,Bild,Telefoner,Biljetter,Resor,Böcker,S tudentlitteratur,Cyklar,Djur,Hobby,Samlarprylar,H� �star,Ridsport,Jakt,Fiske,Musikutrustning,Sport,Fr itid,Affärsöverlåtelser,Inven', 'Vill du sälja, köpa, hyra eller byta?', 'http://www.123rea.se/', '', '[email protected]', 'N', 4, 'v4.1.5', 'default', '3', '4', '3', 'N', 'Thanks you for visit our 123rea.se, we are working on system rightnow...\r\nGood bye!', 'Y', 'Y', 'mail.123rea.se', '[email protected]', '', '', 'Y', '', 7, 'Y', 'default', '', 'logo_logo.jpg');

There are stranger characteres...

My lenguage is Swedish

**Eric Barnes** · 09-09-2009, 08:50 PM

Are you trying to backup the data using phpmyadmin or something else?

lowis · 09-10-2009, 07:02 AM

Yes I just to followed that step that you shown in the forum...

http://www.68classifieds.com/blog/da...th-phpmyadmin/

You can check this link is a printscreen from my phpmyadmin, you can to see many characteres strangers there, I dont know how i going to fix then, thats mean that i cant to make a backup so clear...
all fields appear with the strangers Characteres.
www.123rea.se/images/database.jpg

www.123rea.se/images/database1.jpg

**Eric Barnes** · 09-10-2009, 09:41 AM

When you go to admin is the text all messed up in it as well?

lowis · 09-10-2009, 09:49 AM

No in the admin area everything is ok, but yesterday when I wanted to make a backup for upgrade to 4.1.6 I saw those characteres in my myphpadmin.
I dont know if this could to affect my information into database.

**Eric Barnes** · 09-10-2009, 10:23 AM

What I would do in this case is create a new database and then do your normal export and import everything into your new database. Then probably do a fresh install in a test directory and connect to your new database with the imported data. If everything is still working then all should be fine.

lowis · 09-10-2009, 01:50 PM

Thanks you Eric for your quick replay...

lowis · 09-10-2009, 05:27 PM

Yeah... thanks you Eric rightnow im in the 4.1.6 I kept the same database and everything run OK

09-09-2009, 05:21 PM	#1
lowis Junior Member Join Date: Aug 2009 Location: Sweden Posts: 23 Rep Power: 2	Backup in Mysql Hello somebody can help me I cant to download a backup from my database very well: , INSERT INTO `class_johnadmin` (`id`, `title`, `keywords`, `description`, `url`, `urls`, `email`, `notify`, `maximage`, `version`, `mainTemplate`, `mainIndexCols`, `mainCatCols`, `mainSubCols`, `mainTakeOffline`, `mainTakeOfflineReason`, `mainEmailValidation`, `smtp`, `smtpHost`, `smtpUsername`, `smtpPassword`, `smtpPort`, `mailHTML`, `htmlEditor`, `removeTime`, `showTotal`, `adminTemplate`, `template_title`, `template_logo`) VALUES (1, '123rea.se Sveriges systemannonser', '123,123rea,123rea.se,sälja,köp,byta,hyr,hitta artikel på 123rea.se,TV-spel,Ljud,Bild,Telefoner,Biljetter,Resor,Böcker,S tudentlitteratur,Cyklar,Djur,Hobby,Samlarprylar,H� �star,Ridsport,Jakt,Fiske,Musikutrustning,Sport,Fr itid,Affärsöverlåtelser,Inven', 'Vill du sälja, köpa, hyra eller byta?', 'http://www.123rea.se/', '', '[email protected]', 'N', 4, 'v4.1.5', 'default', '3', '4', '3', 'N', 'Thanks you for visit our 123rea.se, we are working on system rightnow...\r\nGood bye!', 'Y', 'Y', 'mail.123rea.se', '[email protected]', '', '', 'Y', '', 7, 'Y', 'default', '', 'logo_logo.jpg'); There are stranger characteres... My lenguage is Swedish __________________ 68C V 4.1.6 Templatecode Evo-ocean Last edited by lowis; 09-09-2009 at 05:28 PM.

09-09-2009, 08:50 PM	#2
Eric Barnes 68 Classifieds Staff Join Date: Mar 2006 Location: Belmont, NC Posts: 5,121 Rep Power: 120	Are you trying to backup the data using phpmyadmin or something else? __________________ Eric Barnes 68 Classifieds Developer Please do not send me a private message asking for support. Instead use these open forums or our ticket system. Customer Area \| Issue Tracker \| Documentation \| 68C Mods \| Submit a Ticket \| 68 @ Twitter \| My Modules

09-10-2009, 07:02 AM	#3
lowis Junior Member Join Date: Aug 2009 Location: Sweden Posts: 23 Rep Power: 2	Yes phpmyadmin Yes I just to followed that step that you shown in the forum... http://www.68classifieds.com/blog/da...th-phpmyadmin/ You can check this link is a printscreen from my phpmyadmin, you can to see many characteres strangers there, I dont know how i going to fix then, thats mean that i cant to make a backup so clear... all fields appear with the strangers Characteres. www.123rea.se/images/database.jpg www.123rea.se/images/database1.jpg __________________ 68C V 4.1.6 Templatecode Evo-ocean Last edited by lowis; 09-10-2009 at 07:19 AM.

09-10-2009, 09:41 AM	#4
Eric Barnes 68 Classifieds Staff Join Date: Mar 2006 Location: Belmont, NC Posts: 5,121 Rep Power: 120	When you go to admin is the text all messed up in it as well? __________________ Eric Barnes 68 Classifieds Developer Please do not send me a private message asking for support. Instead use these open forums or our ticket system. Customer Area \| Issue Tracker \| Documentation \| 68C Mods \| Submit a Ticket \| 68 @ Twitter \| My Modules

09-10-2009, 09:49 AM	#5
lowis Junior Member Join Date: Aug 2009 Location: Sweden Posts: 23 Rep Power: 2	No No in the admin area everything is ok, but yesterday when I wanted to make a backup for upgrade to 4.1.6 I saw those characteres in my myphpadmin. I dont know if this could to affect my information into database. __________________ 68C V 4.1.6 Templatecode Evo-ocean

09-10-2009, 10:23 AM	#6
Eric Barnes 68 Classifieds Staff Join Date: Mar 2006 Location: Belmont, NC Posts: 5,121 Rep Power: 120	What I would do in this case is create a new database and then do your normal export and import everything into your new database. Then probably do a fresh install in a test directory and connect to your new database with the imported data. If everything is still working then all should be fine. __________________ Eric Barnes 68 Classifieds Developer Please do not send me a private message asking for support. Instead use these open forums or our ticket system. Customer Area \| Issue Tracker \| Documentation \| 68C Mods \| Submit a Ticket \| 68 @ Twitter \| My Modules

09-10-2009, 01:50 PM	#7
lowis Junior Member Join Date: Aug 2009 Location: Sweden Posts: 23 Rep Power: 2	Ok Eric Thanks you Eric for your quick replay... __________________ 68C V 4.1.6 Templatecode Evo-ocean

09-10-2009, 05:27 PM	#8
lowis Junior Member Join Date: Aug 2009 Location: Sweden Posts: 23 Rep Power: 2	Installation successful Yeah... thanks you Eric rightnow im in the 4.1.6 I kept the same database and everything run OK __________________ 68C V 4.1.6 Templatecode Evo-ocean

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Backup Of Site	minerslist	Technical Support	1	11-18-2008 12:15 PM
backup question	wel-usa	v3.1 Questions & Support	3	07-29-2006 10:08 AM
backup.php not running	dawyatt	v3.1 Modules & Modifications	5	05-16-2006 03:24 PM

Support Forums

Backup in Mysql

This topic is resolved.