Making A Database Backup To Local Server And Upload Files To Another?
I want to make a script that backups the *.frm and *.MYD files to my server and I also want to upload those files to another server via FTP? I have a copy of the database files in the directory, that works fine. But my ftp part doesn't! PHP Code:
View Complete Forum Thread with Replies
Related Forum Messages:
Upload Database Backup File
I backed up(using export) a database from one server. Then I went to upload that backup file into another database on another server. I get the error 'File could not be read'.
View Replies !
Cron Job Creating Backup Files In Root Folder On Server
In root folder of my server, I see files like optimize.php.95(optimize.php is the file name we added for cron); files go from .1 and upward. Also happens for other files, seemingly related to the cron jobs we are running. When I open and download the files, there is no content in the files. Do you know what is causing these files to be created? I think they are harmless, except that I think it prevents us from seeing backups generated in root folder, as ftp only allows so many files to be listed. For example, I created a recent backup, but cant seem to find it in the root folder using ftp (I think because these files are crowding out the backups from being listed). Are these files unnecessary? How do we eliminate these files to be created.
View Replies !
Upload From Local Host To Server Using Ftp Functions
On my website I upload files from local computer to my server using FTP functions in PHP. It all works perfectly when I run the script from my pc, but once it s on the server it can t find the file. ftp_put(): error opening C:Documents and SettingsAlexanderDesktop r1_1.jpg I guess it happens cos it tries to find it on the server not on my PC. The question is, how can I point it to my pc, not server. Or how can I make it copy files from my local computer to the server while running from the server!
View Replies !
Making The Server Treat CSS Files Like PHP
Does anyone know if it is possible through the .htaccess file to make the server treat the .css files like .php files, while at the same time, maintaining the .css expectations of the visitors browsers? I was thinking of the benefits of being able to use the dynamic benefits of PHP integrated with the layout power of an external CSS document.
View Replies !
Download Files From Remote Server To Local Webserver
I am trying to create a php page whereby people can download files from a remote server to their own server (to update their webdirectory with updated files/images etc). So for example one php page (e.g. update.php) should be able to download files from a remote server to a specific directory on their local webserver. Is this possible?
View Replies !
Transferring A MySQL Database From Local PC Onto An ISP Server
If I have an MySQL database on my local w2k, how do I transfer it onto my ISP server? The ISP gave me the name of an empty MySQL database they set up for me, the username and the password with no further explanations. I came here from ASP/Access where I was just uploading a mdb file into my webspace. But with MySQL there should be a different procedure,
View Replies !
Use PHPs Upload Feature To Upload Files To My Server Via A Webpage
I'm trying to use PHPs upload feature to upload files to my server via a webpage. Is there a max file size that can be uploaded? Right now my app seems to freeze on anything bigger then 20k. Here is the form I'm using to submit: <form action="index.php?viewBy=uploadEmail" method="post" enctype="multipart/form-data"> <input type=file name=cdFile> <input type=hidden name=MAX_FILE_SIZE value=24000><br><br> <input type=submit value=" Upload Email List "> </form> I'd like to be able to upload files of around 200k in size.. is this possible?
View Replies !
Upload Files To The Server
I need to write a script to upload several hundred files in one go, from my personal computer to the server. Second option is to zip all files as one and unzip them in the server, can this be done with php (unzip)? Mybee some other compress algoritem? winzip is the prefered choice, as this is what the client knows best.
View Replies !
Nobody User When Upload Files On Web Server
This time I've got a terrible big problem about the interaction between a PHP application and the web server filesystem. The PHP application has got many funtionalities, such as uploading small image or text documents, creating directories, and so on. Once I log on the web server filesystem, I notice that all the files have been uploaded correctly, but their ownership is of "nodody" user, "nobody" group and 754 permission. I would like such files should have the same owner of the web files on the server, i.e. "pippo".
View Replies !
Form To Upload Files To Server?
I am trying to figure out how to setup a simple form so someone can upload a file to the server. I have someone out of town I am working on a site for, and want an easy mechanism for them to transfer files to me, images and word docs so I can then pull them into the site. Code:
View Replies !
Upload Files (pictures) To Server From A Webpage?
Is there any way to have people upload files (pictures are what I would like for now) to my server from a webpage? What (if any) built in functions or variables would help me to be able to do this? (actually I just noticed the "attach file" segment below... and this appears to be a php page, so it must be possible)
View Replies !
Ability To Upload Files To A Folder On The Server
1) Gives users the ability to upload files to a folder on the server. Only flash files (.swf) allowed. 2) Information for each server needs to be saved in a My SQL database in certain variables. (name, description, time of upload, user rating, and user that uploaded it from my phpBB users.) 3) The upload is displayed immediately after submiting the upload on a page on a table with a column for each varaible plus a column to allow voting. The name would be a link that opens a pop-up that displays the flash movie. It would generate a list of these tables in order by time of upload. Another list of these table would be in order of rating. Code:
View Replies !
Allows Users To Easily Upload Files To My Server.
I'm attempting to write code that allows users to easily upload files to my server. My dilema of courses is that I dont want to offer a security breach. I'm thinking of creating a form tha calls a .php file that handles the upload. Does anyone have any thoughts on this? The website that I am building will reply very heavily on the ability of new unknown users loading files to the server. Once loaded however they will be quickly screened and deleted once re-sized.
View Replies !
Upload Files To A Database In Mysql
I am trying to upload files to a database in mysql. I am a total beginner and I can't seem to figure it out. Here is my code which is missing code that uploads files because I have know idea. Code:
View Replies !
Upload An Image To The Server And Insert Data To The Database.
I am working on a script to upload an image to the server and insert data to the database. I have 2 parts to this script. The user is not required to upload an image but if they do, I want the script to make sure it is uploaded properly before inserting the data to the database, otherwise if there is no image being uploaded, then just add the data to the database. Below is my code:
View Replies !
Upload & Query MySQL Info Database With Image Files
I want a database I can enter information and upload a photo from a web form. Then I want to query that database for the text info with its related photo and display it (formatted) in a browser (html). Summary: 1. upload photo's and text information to database with my add article form. 2. Query the database and page the results with the text and related photo. It comes in three parts: 1. add_article.php [Text / Photo Upload Form] 2. insert_article.php [Inserts into database] 3. articles.php [View Output] Here is what I have this far:
View Replies !
Php MySQL Works On Remote Server, Only Partially On Local Server
code to populate form select fields with data from a MySQL database, so a user can use those to sort/filter and view the 3,000 records. No inserts -- just selects; very simple. I originally set this up using URL-based query strings at http://stjuliana.org/school/ar/BUindex.php but since that only allowed sorting and not filtering, hence all 3k records load, I made a form verson at http://stjuliana.org/school/ar/index.php . Everything works just fine, however, there's still a lot of tweaking I want to do, such as splitting the form input and output into two pages (_blank), having a printable version, etc. To that end I just set up the latest builds of Apache, php and MySQL on my local Windows XP box, lest I blow my beer budget for the month on bandwidth overage. <g> I have a very simple page I used to test my localhost setup and everything's fine. I can connect to MySQL, create, insert and select from DBs, so I know my config is fine. All my other .php pages on this site work fine locally as well. The two abovementioned pages, however, are giving me fits when run locally... For the URL-query-string version, it loads up with the default view (=name_ns), which grabs all records and sorts by name and point asc. No matter which of the other sort 'views' I might choose, it still loads up all the records in that default sort. The server's holding on to something and I don't know how to clear it. The remote version correctly sorts based on the query string chosen. The form version is worse. It connects to the DB and populates the select boxes with the field data -- that part's fine. But no matter which submit button is selected, no data is retrieved. I get no error, but no data either. The form's action is set to $_SERVER['PHP_SELF'] and I've tried both GET and POST -- no change. Since the exact same pages work on the remote server I know it has to be something on the local setup. But where do I look if there's no obvious error? This is probably something incredibly basic but I'm bleary-eyed from reading tutorials and forums all over the Internet and can't come up with anything.
View Replies !
Sync Directories - Check If Any Of The Files In The Database Have Been Deleted On The FTP Server.
I have a php script on a cron job running every half an hour that FTPs to a given server and downloads files, heres a list of everything it does: 1. Checks file names in the FTP directory with a database table 2. Downloads any new files and imports the file information into that table 3. Uploads all the information inside that file into a different database table 4. Deletes file on the local machine that was downloaded, as to not take up space Now, the FTP directory keeps a full 60 days worth of files which is about 8640 files, everything so far works perfectly, efficiently and doesn't need to be changed. However I want to add a function, in everything it does I want it to check if any of the files in the database have been deleted on the FTP server. As to have only the 60 days worth of file records in the table.
View Replies !
Backup My Server
I use BQbackup.com to backup my server. I know how to do that. But for some reason I cannot find anywhere on google or message boards on how to do a full server restore from bqbackup.com . I dont even know how to get started. BQBACKUP sucks when it comes to support.
View Replies !
Mysql Backup From Files
The hard drive on our dedicated server has "gone bad" (to use the provider's terminology). Though they were able to get our server up and running to the point where we have ssh & ftp capabilities, they keep saying "bad sectors" are preventing them from bringing the whole thing up. I've been scping files over to a temporary location like a madwoman, but since I can't use mysqldump to backup databases, I need to know if there's another way for me to save our database files?
View Replies !
Take Backup Of All Files And Folders
My client is having about 5 sites and he likes to take backup of all files and folders (not sql data) of all his sites. With out using FTP or any other .exe programs. But he likes to take back up of all sites from one master admin site.
View Replies !
Backup Files Aren't Parsed
On my server, these files don't show up in directory listings (yes I know, you shouldn't allow directory listings), however, if you do type in the exact url of the file, it's displayed as source. Just a bit of advice for the super-lazy-or-hasty php people: make sure you configure your server, ftp client, editor, or whatever, to prevent this from happening - it's so easy to think, OK, this script is done, let's go ftp up that directory now, when it's still full of backup files. I haven't read of any exploits ocurring using this method, but then again, I haven't seen warnings on the php sites about backup files either.
View Replies !
Doing Database Backup
I have this site where I runs on 2 server. One is for backup purposes and one is the main server. I have a portal running and therefore, there are heaps of changes going on my database. the question now is, how can i ensure that both have the up-to-date data? if either one does an update, i would like to have both databases being updated as well. never done this before and i don't even have a single clue on how to start.
View Replies !
Backup Database
is there a code that i can export/backup my mysql database from inside a private/admin area of a website? also is there a way to export as say an excell file or sertain sections of a site? i know this can be done inside of phpmyadmin but is there a code to do this from inside an admin section to backup a database/website or download certain section of the website.
View Replies !
Database Backup
PHP Code: $db_connection = mysql_connect("$server","$user","$pass") or die ("No DB Connection"); Â Â Â Â $db = mysql_select_db("$db",$db_connection) or die ("Couldn't select DB"); $table1 = datadump ("options"); $table2 = datadump ("tbl_users"); $content = $table1 . $table2;Â Â Â Â Â Â Â Â function datadump ($table) { Â Â Â Â $result .= "# Dump of $table"; Â Â Â Â $result .= "# Dump DATE : " . date("d-M-Y") ."";.....
View Replies !
I Have 100 Servers Which Need A New Backup Server Added To A Text File,
This seems easy but I have been asking tcl and python IRC chat all day and no one gave an answer. I have 100 servers which need a new backup server added to a text file, and then the backup agent restarted. If I have a list of the servers, all with same root password, and the connection is ssh. How do I connect to the server, cat the line to the config file, stop adn start the agent, and then do same to next server in list and iterate through the 100 servers.
View Replies !
MySQL Database Backup
I'm looking at using PHP and MySQL for a particular website application. However, I was a bit concerned that if a PHP script went wrong then it would be possible to accidentally delete or overwrite large chunks of the data in the database which presumably would then be lost. What is the usual procedure for these situations?. Is it possible to back up a database somehow so that data from a previous time can be retrieved?.
View Replies !
Backup MySQL Database
How does one go about using cron jobs to create a MySQL database dump each evening? I have cPanel with my hosting and when i go to cron jobs i have a 'Command to run:
View Replies !
Php Application For Database Backup
As phpmyadmin I need a database admin tool I have a database of over 47mb need to take backup. phpmyadmin has limited upload capacity of 2048kb only which is not suffice for me. Appreciate if someone can suggest me any option which we even I can offer to my company libra03.com where I am in the support department, we have a large base of customers and we need to provide this solution to many of our clients.
View Replies !
ORACLE Database BACKUP
i m using php as frontend nd. oracle 9i as backend 1.i hv to take database backup after every 30 minute autometically. it must be prgrammed using php. i hv to connect a printer using php. i m unable to use it using my code.
View Replies !
And MySql Database Backup
I have an internet portal based on MySql database and what I need is to make a database backup , after each actualization of data. I know how should PHP code look like but I have no idea how to create SQL command that will backup full database. I know that this group does't concern MySql directly but lots of PHP programmers have wide knowledge of MySql.
View Replies !
How To Upload Local DB
I've created my first dynamic (.php) site for a client. For this site, I've created a mysql database on my local development machine for query testing purposes. I'm able to connect and query this database without any problem. Now, here's the thing: When I'm ready to take this site live, how do I go about uploading the DATABASE from my local box to my client's server space? I mean, I can't find the database on my local machine, even though it is obviously there somewhere. This is kind of like looking for a frog when you've never seen one before. I've looked around in the apache folder (on my local machine) and can't find any mysql anything named "danielik" - which is what I've named the database. There is a folder named "_mmServerScripts" which contains 2 files: MMHTTPDB.php, and mysql.php. Is this the database? I'm sure you folks are gonna just say "oh, yeah, just find the folder that says 'something' and upload that into the 'something folder' on the live site.
View Replies !
Using System/exec, How To Backup Database?
system("mysqldump --opt myDatabase > backup.sql"); here are my problems, i don't think it works on the webserver. next, where exactly the file, backup.sql be place if it does succeed. i believe we just can't execute commands on the webserver can we? i also tried using the sql query BACKUP TABLE ... TO .. but i'm guessing the problem lies with the TO... how do i know what directory shall i place it therE? for instance, my pages are placed in, home/myname/public_html/... i tried to put home/myname/public_html/backup in the TO but nothing happens.
View Replies !
Database Backup Using Exec & Mysqldump
Im trying to get a database backup using ... <?php exec("mysqldump -ulogin -ppassword database > file.sql"); ?> but the resulting file file.sql is written but is empty can anyone suggest where im going wrong.
View Replies !
Database Backup - Two Databases I Need To Combine
I have two databases I need to combine and I can't figure it out through myphpadmin. I'm seeing all over that you can do this: PHP Code: mysqldump --opt -a -u USERNAME -p PASSWORD DATABASE > FILENAME.mysql But I don't understand WHERE I'm supposed to do that, or how, or anything. Even better would be if someone could explain the process and I could just use this: PHP Code: mysqldump -u USERNAM -p PASSWORD DATABASE | mysql --host=123.45.67.89 -C DATABASE .
View Replies !
Restore MySQL Database Backup File Through PHP?
I wrote a PHP script to backup my complete database and send it through email. When I import the file through PHPMyAdmin, everything works. However, when I try to restore the database through PHP (I found similar code on several sites), it doesn't do anything: $restore = "mysqlimport -u $dbuser -p $dbpass $dbname $location"; $importFile = system($restore, $return); This is what $restore contains: mysqlimport -u user12345 -p pass12345 database12345 tempdata/backuprestore/mp_database_15-09-2007.sql I also tried shell_exec instead of system aswell, but this didn't work either. Does anyone know how I can do this with PHP? I need this for my admin panel. PS: mysqlimport is used to import data into a already existing database, right? Since that's what I need.
View Replies !
Backup My Mysql Database To A Flat File
I have been browsing all over the internet, and searching for ways to backup my mysql database to a flat file however; all the scripts I find either just backup the data and not the structure or backup both but it only works if your hosting the db on your machine. Is there a script out there or a tutorial ANYWHERE that tells you how to backup your mysql's database structure and data?
View Replies !
|
TRACKER
