a strange error message?

#21

On 12/31/2011 9:13 PM, Axel Schwenke wrote:

Quote:

Jerry Stuckle<jstucklex (AT) attglobal (DOT) net> wrote:
On 12/31/2011 5:44 AM, Axel Schwenke wrote:

So do yourself a favour and switch to sane tools.

the command line tools coming with MySQL would be a natural
choice. And I also recommend the Percona Tools (former Maatkit).

Please tell us, Mr. MySQL Expert, how is he going to use the command
line tools when he doesn't have SSH/Telnet access (as he indicated
before)?

I haven't seen him writing that. But lets assume he had - then PHP
has a system() function to run arbitrary programs.

Which is disabled in almost every shared hosting environment for
security reasons.

Quote:

He certainly has the ability to upload his own PHP code?

So?

Quote:

I don't think this "discussion" leads anywhere. If your most
sophisticated method of transportation is a bicycle, then you can't
walk on the moon.

Nope. But sometimes you HAVE to walk on the moon and all you have is a
bicycle. You must make do with what you have.

Quote:

Keine Arme - keine Kekse.

Like it or not - PHPMyAdmin is the most popular tool around because it's
better than anything else around (without spending gobs of money, anyway).

It's just better than nothing. I wish I could say the same of you.
In fact I think no answer is better than an answer from you.

Spoken like the true troll you are, Axel. I'm really surprised Oracle
hasn't wised up and fired your ass.

Quote:

You have now stated for the second time that PMA is very superior
and the best next to sliced bread. Still you couldn't say *anything*
helpful. So what's up? Maybe PMA is crap though? Or you're no expert?
OK, I cancel the last question. We know the answer.

XL

So, Mr. Expert, what's a better answer, considering real world
constraints? MySQL CLI isn't, and neither is Percona tools.

Ah, I forgot - you've never worked in the real world, so you have
absolutely no idea what it's like.

In fact, I doubt you've EVER done any real programming. Maybe just some
hacking here and there. It shows.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

#22

On Sat, 31 Dec 2011 08:14:59 -0500, Jerry Stuckle
<jstucklex (AT) attglobal (DOT) net> wrote:

Quote:

I have just remembered that I exported 3 other files using the same
method and none of them gave an error message when imported....what
does that say?

Cheers

Geoff

It says you're trying to import data from a newer database into an older
one - just like others have told you.

Jerry

the reason I mention this is that another sql file which has

/*!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 */;

imports without an error!?

Cheers

Geoff

#23

On 01-01-2012 04:55, Jerry Stuckle wrote:

Quote:

On 12/31/2011 9:13 PM, Axel Schwenke wrote:
........
It's just better than nothing. I wish I could say the same of you.
In fact I think no answer is better than an answer from you.

Spoken like the true troll you are, Axel. I'm really surprised Oracle
hasn't wised up and fired your ass.

......
So, Mr. Expert, what's a better answer, considering real world
constraints? MySQL CLI isn't, and neither is Percona tools.

Ah, I forgot - you've never worked in the real world, so you have
absolutely no idea what it's like.

In fact, I doubt you've EVER done any real programming. Maybe just some
hacking here and there. It shows.

He guy's, grow up...!
(and stop making accusations at each other....)

Let the reader, of each individual article, decide if its of use (and
value) to him/her.

--
Luuk

#24

Luuk wrote:

Quote:

On 01-01-2012 04:55, Jerry Stuckle wrote:
On 12/31/2011 9:13 PM, Axel Schwenke wrote:
.......
It's just better than nothing. I wish I could say the same of you.
In fact I think no answer is better than an answer from you.

Spoken like the true troll you are, Axel. I'm really surprised Oracle
hasn't wised up and fired your ass.

.....
So, Mr. Expert, what's a better answer, considering real world
constraints? MySQL CLI isn't, and neither is Percona tools.

Ah, I forgot - you've never worked in the real world, so you have
absolutely no idea what it's like.

In fact, I doubt you've EVER done any real programming. Maybe just some
hacking here and there. It shows.

He guy's, grow up...!

Jerry wont.

He's too old to start now.

Quote:

(and stop making accusations at each other....)

Let the reader, of each individual article, decide if its of use (and
value) to him/her.

Forget it: that might mean Mr Stuckle looking like an arsehole. So he

wont ever stop.

#25

On Sun, 01 Jan 2012 09:34:26 +0000, Geoff wrote:

Quote:

On Sat, 31 Dec 2011 08:14:59 -0500, Jerry Stuckle
jstucklex (AT) attglobal (DOT) net> wrote:

I have just remembered that I exported 3 other files using the same
method and none of them gave an error message when imported....what
does that say?

Cheers

Geoff

It says you're trying to import data from a newer database into an older
one - just like others have told you.

Jerry

the reason I mention this is that another sql file which has

/*!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 */;

imports without an error!?

As I said elsewhere, this part is not a problem for MySQL. That is,
it is correct, and appropriate. So something that pMA is doing in the
process of passing that particular dump to MySQL is causing the problem.
Ergo pMA is broken and needs fixing. Which (and I can hear it now)
you're not permitted to do either. There is NO WAY to tell what pMA is
doing wrong based on the error message being fed back out. You will have
to do something other than feed the whole dump in in a single go to get
it to work, because that doesn't. This may include handcrafting
dumpfiles.

--
Judging by this particular thread, many people in this group spent their
school years taking illogical, pointless orders from morons and having
their will to live systematically crushed. And people say school doesn't
prepare kids for the real world. -- Rayner, in the Monastery

#26

On Sun, 1 Jan 2012 12:02:14 -0600, "Peter H. Coffin"
<hellsop (AT) ninehells (DOT) com> wrote:

Quote:

On Sun, 01 Jan 2012 09:34:26 +0000, Geoff wrote:
On Sat, 31 Dec 2011 08:14:59 -0500, Jerry Stuckle
jstucklex (AT) attglobal (DOT) net> wrote:

I have just remembered that I exported 3 other files using the same
method and none of them gave an error message when imported....what
does that say?

Cheers

Geoff

It says you're trying to import data from a newer database into an older
one - just like others have told you.

Jerry

the reason I mention this is that another sql file which has

/*!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 */;

imports without an error!?

As I said elsewhere, this part is not a problem for MySQL. That is,
it is correct, and appropriate. So something that pMA is doing in the
process of passing that particular dump to MySQL is causing the problem.
Ergo pMA is broken and needs fixing. Which (and I can hear it now)
you're not permitted to do either. There is NO WAY to tell what pMA is
doing wrong based on the error message being fed back out. You will have
to do something other than feed the whole dump in in a single go to get
it to work, because that doesn't. This may include handcrafting
dumpfiles.

Peter

I have just realised that the importing phpMyAdmin only appears to
allow the use of an .sql file so cannot try a .csv version.

The importing server belongs to a university and they have an older
version of phpMyAdmin than the commercial server from which I have
exported the data.

Cheers

Geoff

#27

On 1/1/2012 9:16 AM, The Natural Philosopher wrote:

Quote:

Luuk wrote:
On 01-01-2012 04:55, Jerry Stuckle wrote:
On 12/31/2011 9:13 PM, Axel Schwenke wrote:
.......
It's just better than nothing. I wish I could say the same of you.
In fact I think no answer is better than an answer from you.

Spoken like the true troll you are, Axel. I'm really surprised Oracle
hasn't wised up and fired your ass.

.....
So, Mr. Expert, what's a better answer, considering real world
constraints? MySQL CLI isn't, and neither is Percona tools.

Ah, I forgot - you've never worked in the real world, so you have
absolutely no idea what it's like.

In fact, I doubt you've EVER done any real programming. Maybe just some
hacking here and there. It shows.

He guy's, grow up...!

Jerry wont.

He's too old to start now.

(and stop making accusations at each other....)

Let the reader, of each individual article, decide if its of use (and
value) to him/her.

Forget it: that might mean Mr Stuckle looking like an arsehole. So he
wont ever stop.

Ah, one of the worst trolls on the internet speaks up again.

Never has added anything of use to usenet - just trolls to satisfy his
ego. No wonder he won't give his real name - he's just a ditch digger
who got fired because he couldn't figure out which end of the shovel to use.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

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

a strange error message?

comp.databases.mysql comp.databases.mysql

Re: a strange error message? - 12-31-2011 , 09:55 PM

Re: a strange error message? - 01-01-2012 , 03:34 AM

Re: a strange error message? - 01-01-2012 , 07:55 AM

Re: a strange error message? - 01-01-2012 , 08:16 AM

Re: a strange error message? - 01-01-2012 , 12:02 PM

Re: a strange error message? - 01-02-2012 , 01:34 AM

Re: a strange error message? - 01-02-2012 , 07:12 PM