GeorgeS: Request for a Bot back-up tool

[Angelox]

Hi and thanks for the tool!
I have a problem;
I always use your tools from a windows client over the LAN to a Linux server.
This time around, when I try to back up Accounts or Bots, it gives me an error 'access denied' to the user@machine I deduct from the MySql. But is is entering the database, as I can edit NPCs and loots.
Here's the runtime error;
-21477217871(80040e31)
It then crashes to desktop

[GeorgeS]

The access issue is odd because I never touched the bot backup code..
The code to backup Bots is

SELECT * FROM npc_types WHERE isbot=1 INTO OUTFILE 'c:/bots.txt'
FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'"

GeorgeS

[Angelox]

whats breaking it is this;

INTO OUTFILE 'c:/bots.txt'

and I already tried without the c:\
Probably a Linux issue, let me look around some

[Angelox]

That was because I had to grant a Global priv 'FILE' in the MySql - now I have a new error;

'Can't write to: /var/lib/mysql/c:/editors/resources/My_bots/Bots.txt'

then it crashes

[Angelox]

As a follow up on this, when I run the query you posted

SELECT * FROM npc_types WHERE isbot=1 INTO OUTFILE 'bots.txt'
FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';

Without the 'c:\' it dumps the bot.txt file on the server in the /var/mysql/ax_classic/

so what it tries to do is dump the file where the server is. and looks at whatever you put in 'c:/bots.txt' as the whole file (windows must default to C:\ , Linux to /var/mysql/database/)

[GeorgeS]

On mine, like your's - if you omit the c:/ path, then it goes to the database folder. The question is then how to save it to where I want it to go for a 'nix environment, and still work with windows systems?

It would seem /var/lib/mysql/c:/editors/resources/My_bots/Bots.txt
is not a legal path (my guess), but the windows function call I made generates -

c:/editors/resources/My_bots/Bots.txt

I'm not sure what would work or how to proceed

GeorgeS

[Congdar]

Cavedude made a backup script for the npc_types table. You get it when you update his database with cvs. There's a bot_npcs.sh and bot_npcs.bat that work pretty good. The other bot tables do not get deleted when you update. You could make backups of the other tables by looking at how his scripts work.