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 RepliesI 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 RelatedI 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.
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?
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 RelatedI am looking for a way to use an ASP.NET button in order to start a backup of a MySql database..
View Replies View RelatedI 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..
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.
I am looking for code that will go through all tables in MYSQL db and transfer records into text or excel files.
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.
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.
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 Relatedim 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 .
just thought you computer-savvy peeps would enjoy a chuckle every once in a while.
View Replies View Relatedi 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 ?
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 RelatedI 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 RelatedI 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 RelatedI 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 RelatedIs 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 RelatedI 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?
I am working on asp and ms sql.
I have created a table called as 'usertable' in ms sql database. The columns in 'usertable' are username, loginid, password. The record gets added to this table, when a new user makes a fresh registration.
Eg: username = 'david'
loginid='daveuser'
password='newpass'
So My question is whenever a new user is added to a table, an automatic mail should come to me 'pra123@yahoo.com' mentioning that a new user is added to table ALONG WITH HIS USERNAME, LOGINID, PASSWORD.
All this information should come to my email account automatically. So how to write ASP Code for this.
I need to some how do the following and if anyone can help me or point me in the right direction I would appreciate it very much.
I have a form that the user would fill out. When he/she clicks submit it goes into another page that reviews the information that the user typed in the previous form. If all of the information is good for the user there's another button in that page that they would have to click.
This is what I want to happen after they click on this button. I want to record the data in a SQL database, which I know how to do that, but what I want to happen automatically right after inserting the data in the SQL database is that I want the same data to be carried over to another page where there'll be another form and want that data to be populated in this new form. How do I do that?
is it possiable in run some automatic checkups on the server every X time or every time (with no reaction with the user). I need to run all the time checkups on the sql database and check values of some column.
View Replies View RelatedI want to add code to the URL so on click will be performed login action with some username and password (ex. h t t p : / / w w w . s o m e - s i t e . c o m /login&username=USER&password=PASS)
I think I wrote total nonsense, but I think you know what I am talking about
If someone want to help me here is that site I want to perform auto login: ...
if there is a way to have a page print automatically, with no dialog box when the page loads, using VBScript or Javascript. This will be an intranet application, running in IE6. I will have control over the browser settings, so those wont be a problem.
View Replies View RelatedAs u see that in yahoo messanger it provide facility for auto fill login and password for specific system. If we want to see our yahoo messanger in my personal sysem then we dont require to fill this user id and password. It automatically fills user id and password. I want to do it in asp.
View Replies View RelatedIs there any way to create automatic generation number like, INW001.......INW002.... ans so on without using any code in ms-access using "autonumber" type with default value.
or
Can you give me the code for creating automatic generation of numbers for a column IDNO , using alphanumeric.
Eg: INW001 , Next should be INW002 ,....... INW010 and so on
where I can get a script which will automatically print a page when its entered or when a form has been submitted. Ive tried to find a script to do such a fing but I really cant find anything to support it.
View Replies View RelatedIs there a way to automatically execute code in ASP? I need to send reminders for one my applications and need some suggestions . how I can send reminder emails automatically.
View Replies View RelatedI have a database that displays an editable record, with buttons for changing to different records. I was wondering if there was a way to store a template email, and have a link on the page that, when clicked, fills the records info into the email and sends it?
View Replies View RelatedI want to know if there is a possibility of mailing the iis log files automatically,say on a daily basis. The problem i am facing now is that my web host is very busy and i need to send dozens of mails to remind him. Also tell me the security previlages needed to execute the script so that i can convey the same to my web host....
And last but not the least can we develop this script with windows nt workstation + iis 4 wihout smtp.
I have created a Store front with .asp & access and I would like to setup something that emails all my users on my mailing list with a Dymanic email with the weeks specials.
But I would like it to happen automatically without any user interaction, say I would like to send it all the users @ 12.00am every monday.
How can this be done?