Database Backup
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
ADVERTISEMENT
Backup Database Included ID
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 ?
Backup Access Database
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 RelatedBackup A Database Table
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 RelatedDatabase Backup Accross Domains
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 RelatedBackup Using ASP
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 RelatedBackup
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.
Backup An Mdb
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?
Backup
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 RelatedASP.NET And MYSQL Backup
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 RelatedASP Mysql Backup
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..
MySQL Backup
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.
BackUp Tables
I am looking for code that will go through all tables in MYSQL db and transfer records into text or excel files.
Backup Restore
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.
MySQL Backup With ASP
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.
FTP Automatic Backup Possible
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 RelatedBackup A Sql Server Db
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 .
Backup A Harddrive
just thought you computer-savvy peeps would enjoy a chuckle every once in a while.
View Replies View RelatedRestore Backup File Through ASP
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 RelatedBackup AccessDB Script
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 RelatedProblem Copy And Paste ASP Code From A Backup CD
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?
Database Limit - Microsoft JET Database Engine Error '80040e14'
I have just started using ASP, I am normaly using PHP but I thought ASP might be a good road to go down. I am having a few problems, I am trying to limit the number of records I take out the database but I keep getting errors.
<%
'connection string
datapath=Server.Mappath("guest.mdb")
strconn="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & datapath & ";"
Set CONN = Server.CreateObject("ADODB.Connection")
CONN.Open strconn
'select all records row by row
DBquery="SELECT * FROM Guests LIMIT 10"
set query=Conn.execute(DBquery)
do while not query.eof
'get a variable from the table
guest_id = query("ID")
guest_name = query("Name")
guest_msg = query("Mesg")
guest_date = query("DateTime")
'print the variable to the screen
response.write guest_id & "<br />"
response.write guest_name & "<br />"
response.write guest_msg & "<br />"
response.write guest_date & "<br />"
response.write "<br />"
'move to the next record
set conn = nothing
query.movenext
loop
%>
I am getting this error;
Microsoft JET Database Engine error '80040e14'
Syntax error in FROM clause.
/guestbook/guest.asp, line 11
can anyone help me?
Microsoft JET Database Engine :: Cannot Update. Database Or Object Is Read-only
I had made a form name 'dform.html' which asks idno, name and phone from the user and after the user clicks on button "save data" sdata.asp is executed. sdata.asp is written to save the values entered for idno,name and phone in dform.html into table "myfriends" in the mydata.mdb (access database). but when i am clicking on save data button i am getting error saying
"Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/SDATA.ASP, line 9"
can please anyone tell me why i am getting this error.
Database Connection String To MySQL-database On A Different Server
I work with ASP for several weeks now and i really like it! But until now i have just used it in connection with my localhost. I made connections to a SQL Database and to an ACESS Database with using the ODBC Tool from WIndows!!
Now i want to publish my website but i don't know how to handle the connection string kind of thing. My MySQL-Database is on a different server than the website and i need a connection string where i can type in the server, a password and a username and it should then connect.
How Do I Export Data Fom Local Database To Server Database?
I'm current working on a project which need to upload local data to
live server database.
Meanings that, i'm current having a server in my local mechine. I need
upload data from local database to live database which host at oversea
company. But i really have no idea how to do this in asp.
Microsoft JET Database Engine , Database Or Object Is Read-only
Error Type:
Microsoft JET Database Engine (0x80040E21)
Cannot update. Database or object is read-only.
/q_maker/aero_admin/delete.asp, line 12
what is wrong! i checked the db and its not readonly.
Using Value From Database Updating The Database And Resuing The Value
i wrote a shopping cart using cookies found out thatIE 7 won't let me add more cookies after a certian number. decided to use DB along with cookies and now i have very weired problem never encountered before Code:
View Replies View RelatedMany-to-Many :: Seperate Database Or One Database?
Products ---> Products|Customer <--Customer
With regardst the above many-to-many relationship:
Is there any advantage in creating seperate access databases for:
- Customer
- Products
....Rather than keeping them as three tables in one database.
The reason I ask is that I have found that if I am using a ftp approach to
overwriting or updating the remote database there are sometimes problems
with synchronizing data .....This seems to be a better solution?
Am I off base?
Web Database
does any one know a simple free database driven website tutorial that i could learn? i need it for when someone searches a name ionformation on that name comes up along with photographs realating to them.
I have built several websites before but none are database driven so is there any dummy proof versions?
Do While Out Of A Database
How do I do a Do While loop to display rows of information out of a database. Here's my code, and it seems like its in an infinite loop. Code:
View Replies View RelatedASP With Database
I have a Access DB with two tables (Users and tblpersons). Users are stored in table Users and their records in tblpersons. They are able to login, Enter, Search, Update their data.
I want users to be able to Enter and update only their data not other users data.
Example:User_Id 1 when logged in, is able to enter data for any user(1,2,3......) and able to modify their data.
Database.mdb
I can make a simple database file and name it database.mdb, all I need to do is name a single field email and save it. But I dont know how to make it so that my page will become active and the emails submitted will be saved either to the mdb file or a text file, im not sure what goes on there.
Database Not
i have 2 tables and i only want the records where which arent in the one database eg.
table 1
idnum
1
2
3
4
table two
idnum
1
2
3
4
5
6
out of these two tables i only want from table two idnum 5 and 6 cause they arnt in the 1st table.