How Do I use 'Save Data File to Server'

[kirupa]

Hello again,
In my forums, I have a folder called test located in the same directory as the other forum folders such as admin, mods, images, etc. Now, I CHMODDED the test folder. In the area in the Admin Control Panel where I specify the folder to backup the database to, what would I write?

../test/backup.sql

or just:

test/backup.sql

Thanks again for the great help all of you have provided =)

Cheers!
Kirupa

[kirupa]

Hello again,
I entered the absolute URL, and after about 10 minutes of waiting on the backup, this is part of the message I received:

fopen("http://www.kirupaforum.com/test/forumbackup.sql", "w" ) - Success in /home/virtual/site37/fst/var/www/html/admin/backup.php on line 264
DROP TABLE IF EXISTS access; CREATE TABLE access ( userid int(10) unsigned NOT NULL, forumid smallint(5) unsigned NOT NULL, accessmask smallint(5) unsigned NOT NULL, KEY userid (userid,forumid) ); INSERT INTO access VALUES('120', '7', '0'); INSERT INTO access VALUES('120', '6', '0');

What exactly does this mean? I really need to backup my database into a different server, and I am getting worried.

EDIT: Also, for the past 5 mins, all I am seeing on the backup page (the same page as the one with the error I mentioend above) is a collection of strange ASCII symbols. Over 90% of my system resources are being used to display page after page of arcane symbols. Should I simply close the browser or keep it running until the page eventually stops downloading?

Cheers!
Kirupa

[Floris]

Little advice, don't put the test directory in a public area, like the admin/test beyond the html/ directory. This is a security risk.

Put it in var/www/test/file.sql
chmod it 777

then you can write to it.

If you get those errors, run repair.php to check & optimize & repair broken tables.

[kirupa]

thanks - I will try it

[kirupa]

I just uploaded the file to my new server, and I have also e-mailed my host about it. What would the be command for importing the .sql file using phpMyAdmin (I know it isn't efficient, but I'm just curious to give it a shot) hehe.

Thanks!
Kirupa