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]