Ok, this is a detailed explanation of what is HAPPENING.
- I make a db dump with the phpmyadmin's function EXPORT (i tried ALL the combinations of options and nothing works): IT DOESN'T WORKS, NEVER! EXCEPT when i try to LOAD it on the SAME MySQL server but another database! And THIS is the strange thing!
- locally it says that there is no query in that file
- I try to make a backup copy of the DB with an external utility but when i do the dump, it says that there are 51 tables and NO data (0 kb).
- what follows is the first part of what i get dumping the database with only data and structure (no complete or extended inserts, etc...). The thing i must say is that if i copy the query into the box the result is an error message because the value '0' is not recognised. If i remove all the " ' " the query is recognised and well-executed.
# phpMyAdmin SQL Dump
# version 2.5.3
#
http://www.phpmyadmin.net#
# Host: 62.149.150.11
# Generato il: 02 Nov, 2003 at 11:25 PM
# Versione MySQL: 3.23.56
# Versione PHP: 4.2.2
#
# Database : `Sql10530_1`
#
# --------------------------------------------------------
#
# Struttura della tabella `xoops_banner`
#
CREATE TABLE xoops_banner (
bid int(4) NOT NULL auto_increment,
cid int(2) NOT NULL default '0',
imptotal int(8) NOT NULL default '0',
impmade int(8) NOT NULL default '0',
clicks int(8) NOT NULL default '0',
imageurl varchar(255) NOT NULL default '',
clickurl varchar(255) NOT NULL default '',
date int(10) NOT NULL default '0',
PRIMARY KEY (bid),
KEY idxbannercid (cid),
KEY idxbannerbidcid (bid,cid)
) TYPE=MyISAM;
I hope I've been clear.
Thnaks for the help.
P.S.: Where are you "great minds"? Are you so busy that you can't answer me? Please, remember of this old XOOPS 1 user that is having problems...