Backup
I have posted a query before and solved the problem myself. What I am doing is using the filesystem object to copy my Access DB to another folder on my site for a backup. I then have a page that says when the backup DB was created, uses the filesystem object as well. My question is that when I backup the DB the page does not display the correct time and date of when the DB was last backed up. Here is my process for backing up the DB:
First I Delete a previous backup and lock the current DB
Then I copy the current DB to replace the copy I deleted
Then I un-lock the DB and return the user to the page that should show the correct date and time.
View Replies
ADVERTISEMENT
I have created ASP application which is on one server. This application uses Access database. Is there some possibility to create an ASP script that will copy my MDB database on some other server?
View Replies
View Related
Web site type: mdb driven shopping cart.ALtho my web host peforms nightly backups, I wish to create one of my own.I intend to do the following:
create a scedule in cuteftp to dload an mdb file nightly.My concern is,that during the dload what happens if someone is reading/writing to the mdb whilst using the website? Could this corrupt the mdb,or would the site throw an error during the mdb dload period?
View Replies
View Related
I uploaded all the files to the website. I am using Access database.Everyday i want to take backup. How can i take backup from ASP and copy to my local system. If any problem in the database i will restore the backUp file.I am using classic ASP. I want to compress the database and backup.
View Replies
View Related
I am looking for a way to use an ASP.NET button in order to start a backup of a MySql database..
View Replies
View Related
I am running some websites and would like to take a full backup of my websites every morning at 5 AM.
Because of my server permissions I need to make some kind of database dump (script I think?), that can be started by a cronjob.
Problem is, I'm a little stuck with this and can't find anything on google..
View Replies
View Related
I'm coming to the conclusion it isn't possible, because I can't find any reference to it anywhere on the web after a good deal of searching. Let me explain my position, I'm writing an admin area which will access and update a large MySQL database. When the asp code runs the update (about once a week), there will be a high potential for things to go wrong, and as a precautionary measure I wanted to perform a database backup before it ran the database updates.
What I wanted to do was similar to the PHPMYADMIN "Export" function, but in ASP, and save the file on the server for me to download at a later date if needed. If I could create the file, I figured that I could save it to a directory with write priveledges on the server using FSO. The problem is actually creating a dump of the structure of all of the tables using an ASP script. I have no idea how PHPMYADMIN manages to do it, but I don't know any PHP whatsoever, and I would far prefer to make it work automatically through the admin area I am scripting in ASP. All the references I could find in the MySQL manual were to creating the backup using telnet access, which we don't have at my host for security reasons, so I wondered if anyone else had come accross this problem before and had a possible solution that could help me [], or whether anyone can say that it definitely is not possible.
View Replies
View Related
I am looking for code that will go through all tables in MYSQL db and transfer records into text or excel files.
View Replies
View Related
As the subject states, does anyone know how I can backup an Access db, using ASP ? Is there a 'copy' statement or similar?Ideally, some method to ensure no one else is logged on, then copy the file from the "physical" path, like retrieving:
request.servervariables("APPL_PHYSICAL_PATH")
for the Access db, then copy the entire db to a sub folder called "/db/backup" . I want to do this remotely, not locally, because there is a lot of testing to do in the next few weeks, and I don't want to have to upload the (good) copy of the Access db evertime some additional changes to the db are to be made. I would like to save the bandwidth.
View Replies
View Related
I need your help to take a backup through ASP script of a MySQL Database.
The whole database need to be back up in a .sql file like backup.sql
so that i can restore that through another script.
View Replies
View Related
I would like to backup the Remote Access database from a link on my asp application . Is it possible ?For instance, there would be a menu which once clicked will initiate login/password and ftp server, get the database and rename it with currentdate, close the connexion ?
View Replies
View Related
I am looking for a script that can take my Access DB and make a copy of it and store it in another folder. Does anyone know where I can get a code or script to do this?
View Replies
View Related
im facing some troubles with a sql server database running on windows server . the problem is i need to backup my database coz i ve lost the local copy of it and i cannot also connect to it via enterprize manager (but it's working good with my site on the serer) .
so i need to create some asp script that reads the names of the tables of this database and also gets the structure of them (fields names and data type of each table) so i can use this data to re-build the database on my local machine .
View Replies
View Related
just thought you computer-savvy peeps would enjoy a chuckle every once in a while.
View Replies
View Related
i want to backup my database included id number..
there are alot table in my database..
but they are not connected with each other..
for example..
table name : products
id | product_name
------------------------
75 ASUS notebook
another table name : type
id | product_id | product_type
----------------------------------
1 75 PIV 3GHZ
2 75 PIV 3.2GHZ
this database is mssql..
how to protect(save) id number while backup database ?
View Replies
View Related
I have one SQL server 2000 backup file,now i want to restore that file using ASP.How can i do this please give me the solution for that .Is there any way for that.
View Replies
View Related
I would like to back up my site database. However, while I am backing up/copying the database, the database might be still in used by visitor.
View Replies
View Related
I have been searching for a script that when i click on backup in the admin section of the site it will backup the database in a backup folder with a datestamp but cant finde it. I dont really know with the backup procedure but a good backup script.
View Replies
View Related
I need to be able to add a button on my site that will backup an SQL table (not the whole database) - does anyone know how to do that?
View Replies
View Related
Is it possible to backup a Database from one domain to another using the File System Object? I want to save a DB from a folder on my1stsite.com to my2ndsite.com but obviously the server.mappath won't work and putting the URL of the folder to save to doesn't either i.e. http://www.my2ndsite.com/savefolder/myDB.mdb .
View Replies
View Related
I have set up a new server and now I try to move all the web ASP files, scripts to my new server.
I do copy and paste all the files to my webroot directory. None of the page works, the browser simplely redirect me to the search engine page. I have about total 50 ASP scripts and files. None of them shows after I entered the address in the browser. No bug and no syntex errors.
If I created a very simple ASP page like "Hello world", it works fine. Then even the Hello world page stopped working after I copy and paste any parts of the code from my backup CD.
I also heard someone mentioned about domain name hard coded program, could it possible in my case?
View Replies
View Related