Support Forums

Backup in Mysql

This is a discussion on Backup in Mysql within the Technical Support forums, part of the Technical Support Forums category; Hello somebody can help me I cant to download a backup from my database very well: , INSERT INTO `class_johnadmin` ...


Go Back   68 Classifieds Forums > Technical Support Forums > Technical Support

This topic is resolved.

If you have a similar issue that this thread does not address, open a new related support topic.

 
Thread Tools Display Modes
Old 09-09-2009, 05:21 PM   #1
Junior Member
 
lowis's Avatar
 
Join Date: Aug 2009
Location: Sweden
Posts: 23
Rep Power: 2
lowis is on a distinguished road
Exclamation 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 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.
lowis is offline  
Old 09-09-2009, 08:50 PM   #2
68 Classifieds Staff
 
Eric Barnes's Avatar
 
Join Date: Mar 2006
Location: Belmont, NC
Posts: 5,121
Rep Power: 120
Eric Barnes is a jewel in the rough
Default

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
Eric Barnes is offline  
Old 09-10-2009, 07:02 AM   #3
Junior Member
 
lowis's Avatar
 
Join Date: Aug 2009
Location: Sweden
Posts: 23
Rep Power: 2
lowis is on a distinguished road
Exclamation 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.
lowis is offline  
Old 09-10-2009, 09:41 AM   #4
68 Classifieds Staff
 
Eric Barnes's Avatar
 
Join Date: Mar 2006
Location: Belmont, NC
Posts: 5,121
Rep Power: 120
Eric Barnes is a jewel in the rough
Default

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
Eric Barnes is offline  
Old 09-10-2009, 09:49 AM   #5
Junior Member
 
lowis's Avatar
 
Join Date: Aug 2009
Location: Sweden
Posts: 23
Rep Power: 2
lowis is on a distinguished road
Default 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
lowis is offline  
Old 09-10-2009, 10:23 AM   #6
68 Classifieds Staff
 
Eric Barnes's Avatar
 
Join Date: Mar 2006
Location: Belmont, NC
Posts: 5,121
Rep Power: 120
Eric Barnes is a jewel in the rough
Default

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
Eric Barnes is offline  
Old 09-10-2009, 01:50 PM   #7
Junior Member
 
lowis's Avatar
 
Join Date: Aug 2009
Location: Sweden
Posts: 23
Rep Power: 2
lowis is on a distinguished road
Default Ok Eric

Thanks you Eric for your quick replay...
__________________
68C V 4.1.6
Templatecode Evo-ocean
lowis is offline  
Old 09-10-2009, 05:27 PM   #8
Junior Member
 
lowis's Avatar
 
Join Date: Aug 2009
Location: Sweden
Posts: 23
Rep Power: 2
lowis is on a distinguished road
Talking 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
lowis is offline  
Closed Thread

Thread Tools
Display Modes


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


All times are GMT -4. The time now is 11:01 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0