I read the great FAQ Giz wrote on backups. Network Solutions won't allow access to a shell account to execute commands. I have 7.1 of the product installed by Rick. I closed the board this morning to try running the backup function in the product. My website is in a folder called htdocs and the product is underneath that. Above the root is a cgi-bin directory and a backup directory used by Network Solutions to give me a backup of the html files every night. (They do not allow me to write to that directory and I am not allowed to add a directory above ht-docs UNLESS I create new directories in the cgi-bin directory.)
When I execute back up all tables the execution goes to the table just after ubbt_user_posts and just quits. Nothing is written into the backup directory. I tried just backing up the ubb_user_posts table by itself and same thing. At the moment I'm trying to send the backups to a backup folder in the cgi-bin directory thinking where the backup is going is causing it to fail.
...but then I remember Giz wrote that backups done inside the product might time out. Rats.
I do have access to the myPHP database access screen. I've jumped up there to repair tables before. Keep in mind I understand just enough to be dangerous. I do try to be careful and ask questions before I break something.
Can I backup the entire database there?
Getting help from the ISP is fruitless. I spent over an hour trying to get a telephone answering rep to understand my plight. They follow scripts and understand less than I do. No is the only word they understand. It took them seven days after one of my rants to tell me they don't allow access to a shell account for backups and THEN OFFERED NO SOLUTION to the problem. Nothing, zip, nada. With some ISP's you're all alone on a desert island and have to fend for yourself I guess.
WordPress has an internal widget that allows me to backup data but even it will timeout on large tables. I reduce the size of a growing table to 1 week's worth data from 1 month and I can now get through a backup. A great backup program by Lester (Gamerz) can't be used because the ISP won't tell anyone the path to mysqldump and the conventional variables or directory names do not work.
It concerns me that I can't get through a backup of one table in UBB though. Perhaps the only answer is doing them all one at a time and using a unique file name?
What kind of a file is produced and where does it go if it doesn't go to the place shown in the backup screen? The directory path test good and is writable. Has anyone done a step by step process for using the PHP interface to the database? Is there an SQL backup script I can run there? What do I need to ask the ISP to fix so that backups finish?
I am lost in Backup Land but UBB still rocks!
