[SOLVED] Mysql database export old character

[Renissi]

Hello,

 

First post here. Forgive me that i didn't search in the other 283 pages of mysql help.

 

We have a server for the last 4 years, and they updated a lot on the phpmyadmin site.

 

Here are the settins of that server:

 

MySQL

* Server: xxx.xxx.xxx (xxx.xx.xx.x via TCP/IP)

* Server version: 5.0.67-log

* Protocol version: 10

* User: xxxxxxxxxxxxxx@xxx.xx.xx.x

* MySQL charset: UTF-8 Unicode (utf8)

 

Web server

* Apache

* MySQL client version: 5.0.67

* PHP extension: mysqli

 

phpMyAdmin

* Version information: 3.1.2

 

I am a noob with 2 questions, and i really hope someone can answer them.

 

When i export a database as a sql file it says:

 

-- phpMyAdmin SQL Dump

-- version 3.1.2

-- http://www.phpmyadmin.net

--

-- Machine: xxx.xx.xx.x

-- Genereertijd: 02 Apr 2009 om 16:52

-- Serverversie: 5.0.67

-- PHP-Versie: 5.2.9

 

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

 

 

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

 

--

-- Database: `xxxxxxx`

--

 

-- --------------------------------------------------------

 

--

-- Tabelstructuur voor tabel `xxxx`

--

 

CREATE TABLE IF NOT EXISTS `xxxx`

 

Etc etc

 

This line SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; i have seen before in my backups, and have no idea why that was there.

In my first backups i don't have those lines.

 

And these:

 

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

 

These are new for me, and i have no idea why they are there.

Can someone tell me what to do with those lines? Ignore?

__-__-__-__-__-__-__-_

 

When i export a database i get a file with databasename.sql

when i open it in notepad all text is full over my screen.

 

See the attach.

 

For example: 'Fan added', '14/7/1987 Los Angeles', 'setlist.php?date=641'),

('2008-06-08 15:40:59', 'Fan added', '19/2/2008 Katowice', 'setlist.php?date=1252'),

('2008-06-09 18:30:49', 'Ticket added', '8/6/2008 Austin', 'setlist.php?date=1287'),

('2008-06-10 07:25:55', 'Fan added', '9/6/2008 Houston', 'setlist.php?date=1288'),

('2008-06-10 08:40:18', 'CD artwork added', '12/5/1996 New York', 'setlist.php?date=917'),

('2008-06-11 07:01:38', 'Fan added', '6/6/2008 Dallas', 'setlist.php?date=1286'),

('2008-06-11 07:04:21', 'Fan added', '21/8/1996 Dallas', 'setlist.php?date=952'),

('2008-06-11 07:07:09', 'Fan added', '7/12/1997 Dallas', 'setlist.php?date=1018'),

('2008-06-11 07:11:11', 'Fan added', '25/5/2000 Dallas', 'setlist.php?date=1082'),

('2008-06-11 07:13:54', 'Fan added', '14/8/2004 Dallas', 'setlist.php?date=1170'),

('2008-06-12 11:06:33', 'Poster added', '10/8/2007 Sydney', 'setlist.php?date=1219'),

('2008-06-12 12:32:46', 'CD artwork added', '25/5/1989 Wien', 'setlist.php?date=715'),

('2008-06-12 12:44:09', 'DVD artwork added', '25/5/1989

 

when i copy all txt into a word document, the tables are good readable:

('2008-06-07 00:01:11', 'Fan added', '14/7/1987 Los Angeles', 'setlist.php?date=641'),

('2008-06-08 15:40:59', 'Fan added', '19/2/2008 Katowice', 'setlist.php?date=1252'),

('2008-06-09 18:30:49', 'Ticket added', '8/6/2008 Austin', 'setlist.php?date=1287'),

('2008-06-10 07:25:55', 'Fan added', '9/6/2008 Houston', 'setlist.php?date=1288'),

('2008-06-10 08:40:18', 'CD artwork added', '12/5/1996 New York', 'setlist.php?date=917'),

('2008-06-11 07:01:38', 'Fan added', '6/6/2008 Dallas', 'setlist.php?date=1286'),

('2008-06-11 07:04:21', 'Fan added', '21/8/1996 Dallas', 'setlist.php?date=952'),

('2008-06-11 07:07:09', 'Fan added', '7/12/1997 Dallas', 'setlist.php?date=1018'),

('2008-06-11 07:11:11', 'Fan added', '25/5/2000 Dallas', 'setlist.php?date=1082'),

('2008-06-11 07:13:54', 'Fan added', '14/8/2004 Dallas', 'setlist.php?date=1170'),

('2008-06-12 11:06:33', 'Poster added', '10/8/2007 Sydney', 'setlist.php?date=1219'),

('2008-06-12 12:32:46', 'CD artwork added', '25/5/1989 Wien', 'setlist.php?date=715'),

('2008-06-12 12:44:09', 'DVD artwork added', '25/5/1989 etc etc

 

how can i edit this file? in notepad or in word.. I know i can edit in both.

But someone told me once that i can't copy the txt from a databasefile in notepad into a word document

then edit and put it back in the notepadd file.. And import it back in my database..

 

Please can someone help me with some answers,

 

Thank you very much.

Renissi

 

[attachment deleted by admin]

[fenway]

I would NOT worry about those settings -- if you're server has those set, don't change them in the backups.  As for editing, use wordpad, not notepad.

[Mchl]

But not in Word either.

Notepad++ works fine too.

[fenway]

But not in Word either.

Notepad++ works fine too.

Ugh -- Word.  Basically any editor that respects DOS/UNIX filetypes.

[Renissi]

Thank you all..

 

I leave those lines alone...

 

 

Notepad ++ it is...

I'm using it right away..

 

Have a nice day

 

Regards,

 

Renissi