Uploading Existing Database
I just got a dedicated server and can't upload some of the larger databases. I have tried compressed (gz) as well as the none zipped and automatic. None works for a 50MB + database.
I am not sure what's wrong, maybe it times out, but then I never get the error. If that's the case then how do I change the timeout settings in MySQL. Also I am using Plesk, not sure if that matters.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Script For Uploading Data From Local Database To Production Database
I am using MYSQL 4.0 for my local and production databases. I want to extract selected records from selected tables from local database and upload them to my production database on daily basis. In other words, I want to upload data which is entered in local database on daily basis to my production database.
Uploading A Database
I'm very very new to mysql, and i am having huge problems! I am using fedora core 2 Operating system. I have been e-mail a file for a project, which i have to put into myql db, when i try mysql -u -root -p file name > filename i am being prompted for a password, but it won't accept any of the passwords I have set on machine, any idea how i can find out what this password is?
Uploading A Large Database
Can someone please comment on how to host a large database - a database of about 500 MBs. Is a database of this size going to work on a shared hosting environment or is a dedicated server a must? And, how would you go about upload or importing the database to the host? I could be wrong, but I don't believe phpMyAdmin will allow importing a file over 50 MBs.
Uploading MySQL Database
I have a pretty large mysql database that I have to upload into my sql. It is a .sql file and I need to upload it through phpMYadmin or some other way that someone could tell me about. But here's what happens. I click on the SQL tab at the top in phpmyadmin, paste in the database, and click go... about 5-10 seconds later, the page goes to a "no page can be found" ... like a 404 display error.
Uploading Large Database.
I am trying to upload a large mySQL database of 120mb. the file was downloaded from cpanel using the backup facility and is called forum.gz. I have placed it on the root of my server for the time being.
Uploading MySQL Database
I recently created a website and my hosting company gave me 25 MySQL databases that I can use. I'm familiar with MySQL but only through local networks, I've never tried to connect a database out of my local intranet. Through phpmyADMIN, I've created a table and put some information in it. Now i would like to be able to access it through my webpage. I've tried calling the hosting company but they can't seem to help too much. Do I have to export that database to my ftp folder or what? I talked to one of there reps and he said yes but he wasn't sure how to do that.
Uploading Database To Server
I've got MySQL installed on my PC, and created a database called "CMF" for a client's website. Now I'm setting up MySQL access with my new hosting service, and I'm trying to upload the CMF DB to the server so the client can view my progress. To do this, I am trying to use mysqldump.exe to export the DB. In Windows command line, I type: mysqldump.exe -e -n -uroot -pyeha -hlocalhost cmf > c: empcmf-mysqldump.sql and I get the error: mysqldump.exe: Got error: 1045: Access denied for user 'ODBC'@'localhost' (using password: YES) when trying to connect Am I anywhere near the right track on this? Can I (or should I) create/upload databases or tables using MySQL Query Browser?
Uploading My Database To Host Server
I have created a dump of my database using DB Tools. I then log into my server & from the cpanel I choose mysql admin tool. I then choose the SQL tab & choose the file & then get the above error!?!?! Code:
Uploading Mysql Database On Server
I alread have a database in MySql which has already been populated. I wish to upload this onto my server/ test it on apache on my computer. I've configure mysql, apache and php. But when i open my index file in IE, I get this message: Code:
How To Apply New Database Structure To An Existing Database, Without Overwriting Data?
I am writing a simple blog software application. We released a version of this software a while ago. It comes with a sql-tables.sql file, that you can just import into your mysql database and it will setup all the tables for you, for a fresh installation. We made the sql file by just doing an export I believe, without exporting the data that was in OUR database. Well, since then several people have downloaded and installed our software, and are using it. We are about to release a new version soon, however. Since it is all still under development, many things have changed in our database structure. We've added new tables, and modified or even removed fields from existing tables. So for the new release, we're going to include a new sql-tables.sql file obviously, so that for fresh installations they can still install it just like normal. However, the question is... how do you "upgrade" all the previous version's users's databases, without losing any of their data? Is there anyway to export just the structure of our current database... then somehow apply it so that it just goes through and changes another database to match the new structure? Or any ideas at all how to do this?
Using Existing Database
I am setting up a new dev. machine and need to get an old database into the new installation of MySql. There are two databases showing on the database list 'mysql' and 'test'. Can I drop the old database (contained in a folder) straight in with the existing databases and get any sense from it?
Existing Database
I'm using MySQL 4.1.9-nt & VC++ 6.0 . how to get all the database names and table names? I'm using the VC++ syntax, CRecordset rs(&db); //here db is object of CDatabase class. rs.Open(AFX_DB_USE_DEFAULT_TYPE,"show databases ");
Best Way To Get Data From Existing Database
what I'm trying to do is get data from an exhisting oracle database that is not looked after by myself but I have access to. What I want is for my MySql database to mirror the oracle one or update every 5mins or so. I have done a quick search but as I have only made simple databases before I'm not sure what to search for!
Attaching An Existing Database
I would like to attach an existing database (I have the files from another system) to MySQL running on a recovery machine - yeah, the Linux system got screwed, but I managed to recover the files. So, having the database files (.myi, .myd and .frm), how do I go about incorporating them into the current system? (Like "attach database" in MSSQL)
Moving An Existing MySQL Database From
I have an existing database already created on 4.0.25-standard. It is too large to import to my new server via phpmyadmin, so I'm using mysqldump. The new server has MySQL 4.1.12 instead of 4.0.25. I am running this command: mysqldump -u root -p starfall < smf1 --create-options --compatible=mysql40 but I get this: Code:
Create Php Site From Existing Database
I have been contacted by one of my clients to construct a knowledge bank based on their ms access database. I have successfully converted the ms access database to MySQL using the GUI conversion tools supplied by MySQL.com . I am wondering, and I don't know whether this is the right site to do this, if I can easily create a php site based on the database tables that have been converted.
Import Some Tables Into Another Pre-existing Database
I want to dump all but 6 tables of a database into a sql file. THe below is all but those six tables (do I have to wrote out all the table names??) mysqldump -u root -p --opt dbname --tables view_history top_level_feed tag_set pending_tag_set pending_tag pending_fact namespaced_predicate main_search_ns_pred main_search_keywd_pred main_search_keywd_ns_pred main_search_facets main_search_descr_pred main_search_descr_ns_pred job_watcher job_log_entry item_address_watcher feed_watcher feed_log_entry feed_group feed entity_type_sample_uri entity_type dw_user content_search_ns_pred content_search_facets colleague_search_ns_pred cnt_search_keywd_pred cnt_search_keywd_ns_pred cnt_search_descr_pred cnt_search_descr_ns_pred browse_trigger_pred browse_trigger_ns_pred browse_template browse_ns_pred auto_feed > dbNameTables917.sql Then import them into another database that has all these tables already. I want to overwrite these tables with new data from the dump. Will the mysqldump utility work or should I use the mysqlimport dbname --lock-tables --delete /path/to/sqlfile.sql work?
Table Joins On Existing/Non-Existing Data
I have a question that involves a joining tables on potentially non-existing data, but we will know the expected values whether they exist or not. Say we're keeping statistics on any given number of sports for attendances over weekly time periods. There's two tables to hold data. ------------------------------ TABLE: StatisticTypes id name ------------------------------ TABLE: Statistics id statisticTypeId value date ------------------------------ Then, say, we have three entries in the StatisticTypes table for types of sports we're keeping data on...
Duplicate Existing Database (innodb), Structure Only, Without Data
There's a database (innodb) named "test1". I want to create a new database with exact the same strcuture, but since there are many tables in this db i do not want to retype the whole commands. I'm looking for a possibility to duplicate this database, any ideas / tools?
Uploading Php
i wrote a code in php that connect to mysql database in my computer and every thing is ok, but i want to upload these files to the internet, how can i do that? i mean in which directory should i put these files? for more illustration, the directory that my files in is c:apache... and the database is in c:apachemysqldatamydatabase (the name of the database is "mydatabase").
Mysql - Uploading
What I'm doing is uploading an image, then inserting a bunch of data into a table, like username and date and what not, and the path to the picture on the server in the webspace. The problem is, I want the picture to have a filename of say like adnumber-pic-1.jpg, and the problem is, that I have to insert the data before I can get that adnumber, because that adnumber is an auto generated number created by the mysql server. So what I need to know is, right directly after I insert the data into the database, is there a way to return the primary key which is the auto increment value? I think it is somehow, I just dont know where to look for such a thing.
Uploading To Server
Will I have to upload the MySQL program to the servers? Or should he already have it on his servers? ----------- Now a few other questions ----------- 1. How do I sign up for a MySQL account? Someone on another forum told me I needed to set up an account before he could help me set up my 'forum'. 2. Does it cost money to set up an account?
Uploading A .doc File
Here is what I want to do: A user fills in a form with the path to the .doc file on their PC, then clicks upload. The file is uploaded to a some folder, and the path to the file is stored in the mysql db. Is there a way to do this? An example with a fictitious DB would be great. PS. Is there a way to convert a .doc file to HTML where it will retain all of its properties? (Like italics, bolding, underlines etc.)
Uploading Data
i cant believe this ffs basically - i had to empty my table, and then upload a new batch of data and now its throwing errors at me basically its all in a csv file - with ; as dividers for the columns etc at the beginning of the file i have a ' - to allow it to open in .csv mySQL is rejecting the ' part? what do i do - as if i dont include the ' - mySQL also rejects it
Uploading MySQL DB
Has anyone ever had to upload their MySQL database from their own computer up to a server? I am trying to get mine uploaded to pulsehostings.com and I am getting the run around with their tech support in getting my DB uploaded. Anyone know what a "dumpfile" is and how to create it? I sent all of my table files, but they said that wasn't what they needed. They refuse to elaborate on what exactly they do need. All I know is that it isn't the table files. I can't find any other file that pertains to my database whatsoever on my computer. Any ideas on what they want or play-by-play accounts of uploading a website including a MySQL database to a webserver would be greatly appreciated as this is my first time trying this.
Uploading Images
I'm trying to create a form which has an image upload field. I know how to display the resultant image, following the correct file paths, etc. The thing i can't do is get the actual image onto the server via the form.
Uploading Databse
i am uploading a database to a newer version of mysql than where it was originally hosted.My problem is it is giving me syntax errors. Is there a way for me to be able to sort this out so it will upload succesfully. I am no expert at all on db's so any help is appreciated on this
Uploading A CSV File
I am having some issues uploading a CSV file into a Mysql table. I have a table with 2 columns PRODCODE and product_quantity my CSV file has 2 columns. I have tried clicking import and impoting the CSV file. This throws back an error 'Invalid field count in CSV input on line 2029.' I have put in the top of each column the name prodcode and product_quantity but still no joy. If I do CSV using Load data then it seems to work but my values are not updated. I have checked down to line 2029 and there is nothing on there that would cause an issue.
Uploading An Image
I have a database on my easily website. I am able to upload to this with ASP script. Before I have been able to upload using the following format: sql ="insert into table(table,table)values('"&request(table)&"',?)"
Uploading My MYSQL
I have completed my first MYSGL and Coldfusion and it all works fine testing on my computer, but how do I upload it? I can upload all the html and cfm coldfusion files fine, but it doesnt work, because there is no database MYSQL fille resident on the server. How do I upload my project?
Uploading CSV File Through Phpmyadmin
I'm trying to upload a csv file into my MySQL database through phpmyadmin. I'm using godaddy.com as a host. They're using the latest version of phpmyadmin, but it looks like a "dumbed-down" version, or at least not giving me total administrative priviledges. Anyway I'm trying to upload a simple csv file, just 1 line of text, into my database. I have 3 fields so I'm trying to upload one line with 3 text objects in that line. Whenever I try to upload this thing it gives me a MySQL syntax error #1064. I've tried getting csv files from different companies and uploading theirs after adjusting the amount of columns to fit my database, and I'm still getting the same error.
Uploading Tables From Wamp
i have been working on a test project in wamp. and now i am trying to run it online. i already uploaded all the html and php files and its now up and running except the databases. my question is, how do i upload my mysql databases or tables? on what directory should i put the mysql files?
Saving An SQL File For Uploading
I have saved a create table script, but have noticed that it appears to be only as a TXT file rather then SQL file typ. How do i change this extension so that i can get SQL to find it?
Uploading MySQL Databases
I need to know if anybody can help me with this: I have developed a php app with mysql database. Now I need to upload my app to be online, which I've done today. Now I need to upload the database. all the hosting companies I've consulted, say that I must CREATE the database in their servers... my problem is that I ALREADY have the database (more than 26 tables, populated with data) and don't want to CREATE it again. I don't have experience working with online databases, so I really willl appreciate if anybody can explain me if there is a way to upload an existing mysql database from a localhost to the server of a hosting company.
Uploading A Word Document
i've researched this topic extensively and every bum that thinks he knows how to do it runs into the same issue, when uploading the file into a blob or medium blob through opening it, reading its content, adding slashes and then placing it in the datafield it gets all junked up with crazy characters and salvaging any amount of useful information is impossible. So does anyone have an example of how to properly upload a word document into a mySQL data field blob or medium blob?
Uploading Images To MySQL And Displaying Them
I am working on a site that is heavy on template usage and therefore am in the position to use one template to grab content (including images) from a database. This seems like an easy enough question, but none of the materials I have cover the basics on how to accomplish something like this.
Creating A Data Dump & Uploading To Remote Server
I've just taken an intro class on PHP and MySQL. I've got the technolgies running on my local machine. I can't seem to get a detailed, easy to understand, step by step guidance on how to transfer what I've got locally to my remote web host who is running MySQL and phpMyadmin. I'm running MySQL Server 4.1. Need to know how to copy my SQL tables and database to a sql file and then upload.
My.cnf Not Existing
this is my first posting here so plz do not flame me too much if my quest= ion=20 marks me as a total noob. My problem is, i play around a bit with mysql (4.0.13) and want to test t= he=20 Replication. The Documentation at http://www.mysql.com says i have to do = the=20 following: Stop databases - done. Build tarball of data and bring it on slave - done. Modify my.cnf - ??? Here is my problem. There is no my.cnf existing on my machine. Maybe its=20 called different with the newer version? Or can it be considered empty an= d i=20 have to build a new one? But if i have to, in which directory would i do=20 that?
ON EXISTING Clause
What I'm trying to do is update a table of mine in mySQL. However, some of the values may not exist in the table yet, while most will already be there. I have done some searching and I think I need help. I'm assuming UPDATE won't simply act as an INSERT if the existing value is not found. From my searching it seems I need to use the ON EXISTING clause with an INSERT. However, it seems that ON EXISTING can only be used when there is a primary key. In my case, thats not the case here. However, for me this is query confusing at the moment. Can someone provide a hand? My table is called "rankings" and has the following structure: comp_id - int (and an index) uid - int networth - int
How To Add A New Row To An Existing Table?
I am able to create database, tables, inserting values, and so forth. My question is this: Let's say I have a table on the list of items I owned, and some time later, I need to add a new item between after row 12 and before 13. How do I do that? I did look at MySQL 5.0 Manual and didn't find anything similar to what I wanted to do.
Check For Existing Row ?
How do I determine if a row already exists ? // see if a row has id=100 $id=100; $query="SELECT * FROM mytable WHERE id=$id"; $result=mysql_query($query); ...what do I check now ?
Information From Existing Db
Dont know much about mySQL, so excuse my potential ignorance here : Is it possible for a table to write information to another table automatically? For example, if on "table1" I have a column called "code", can I write the entire contents of a specified row to another table called "abc" if the code "abc" appears in the "code" column of "table1"
Add A Record To An Existing Recordset?
I have a MySQL table with about 30 records, I use a form to insert data into the first 24. (like; Name, Phone, etc...) The last 6 (Photo1, Photo2, Photo3, Photo4, Photo5, Photo6) are the names of uploaded images (which are uploaded from a seperate form. How do I (Or what MySQL statement do I use) to insert the 6 names into the recordset? (Each image name will be saved into a php variable. ($Img1, $Img2, $Img3, $Img4, $Img5, $Img6)
Using Update To Add Value To Existing Numeric Value
I have users inputting hours into a mysql database. Is there a way to have a mysql statement take my input and add it to the existing value in a record? I suppose I could just select that value and use php to add the 2 values but was thinking mysql might have a function to do this for me.
|
TRACKER
