How To Upload Database To WordPress?
I just recently bought a website and I’m having a problem with the website not showing up.
I installed Wordpress through Fantastico, dropped the tables in MyPhpAdmin and imported the SQL file sent by the seller. All went smoothly but when I visit the address, nothing shows up.
Is there something I missed? Should I install manually? Should I add the database first before installing Wordpress?
View Complete Forum Thread with Replies
Related Forum Messages:
Wordpress Database Help Needed!
I'm trying to import some content into the wp_posts database, which works, but I can't figure out how to make it automatically publish at a later date. When I publish the imported content manually (eg. edit timestamp and hit publish) it works, but when I try and upload that into the database, it doesn't seem to register. I'm doing some traveling soon and I don't want the blog to lay dormant! Here's my SQL for an example post: Quote: INSERT INTOwp_posts(ID,post_author,post_date,post_date_gmt,post_content,post_title,po st_category,post_excerpt,post_status,comment_status,ping_status,post_password, post_name,to_ping,pinged,post_modified,post_modified_gmt,post_content_filtered ,post_parent,guid,menu_order,post_type,post_mime_type,comment_count`) VALUES (123, 1, ��-11-21 17:45:39', ��-11-21 23:31:15', 'I AM THE POST CONTENT', 'THIS IS THE POST TITLE', 19, '', 'future', 'open', 'open', '', 'this-is-the-post-slug', '', '', ��-12-01 17:45:39', ��-12-01 23:31:15', '', 0, '', 0, 'post', '', 0);` So all times are set in the future, and the post_status is "future". Why is it not publishing when the time comes around?
View Replies !
Phpmyadmin Mysqldump And Wordpress Database
Hey I have a wordpress database on my vps server that i want to move to my shared server account. The database is originally on the vps which uses phpmyadmin 2.8.2.4, so I go to export and export the database. Then I log onto my shared server that has phpmyadmin 2.6.4, and I import tha wordpress database. I get this error in return:
View Replies !
Error Establishing A Database Connection - Wordpress
In the early part of January my wordpess was working fine it installed fine, I was able to get my old database migrated into wordpress with some help. I then had a hardware problem on my computer and I was unable to connect to the internet, that being said I can't remember if this problem happened just before or after I was able to get back online. Either way wordpress can't connect to the database, I've been informed that the problem has to do with that either the password or login name is incorrect causing wordpress to give me that error as it can't find the database. I've been told to edit my wp-config.php file and I've tried it and nothing worked,
View Replies !
How To Upload Database
This may sound like a silly question, but i m working with mysql and php for the 1st time. After creating the website, how does one upload the mysql database on the webhost? can i upload through mysql administrator? what type of file does one upload? basically i have no clue. Also can i store non-english text in mysql? will i be able to show it on the web page? what if the user doesn't have the specific font i use.
View Replies !
Upload Database
I create a database in my pc. now i need to upload it to remote server(I use third party hosting companies), but I don't know how to do that!!? I have mysql admin software and also I know the command:mysql dump may help,
View Replies !
Upload My Database
Im an absolute beginner with mysql and have successfully setup and have working a licensed copy of VBulletin of which I have uploaded the php files for, but not the database.I am completely lost here. How do I upload the mysql database to the web server?
View Replies !
Database Upload Problem
I'm trying to upload my MySQL database to my host. My host is using MySQL version 4.0.17, and I'm using version 4.1.8. When I use the "gzipped" compression option to save the database from within phpmyadmin (to create a .gz file for upload), the upload process finds fault with the first line: CREATE DATABASE `database` DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci; I've been told on this forum (by Guelphdad (Dave L.)) that the problem results from the COLLATE clause which didn't come in to MySQL until release 4.1. So I'm trying to use the 'none' compression option. This causes DirectAdmin on my host to report: Success! Details Database has been successfully Restored But when I go to check it using phpmyadmin on my host, it reports that there are no files in the database.
View Replies !
Error Upload Database
I've concluded that it is not physically possible to upload a database onto my hosts machine.I persist in trying to prove otherwise. Why would I get the error message: Error Restoring database. That database is not yours. from DirectAdmin? From within DirectAdmin on my host, I'm not logged in as ANY database user surely? There's no database there yet!! What priviliges need to set up on my computer to allow me to export it?
View Replies !
Upload Database To WebServer
New to mysql and running it on XP Pro, server ver 4.0.2, client ver 5.0.I've created a database which is used on my website, when I test it locally it all works fine, but I need to upload it to a linux webserver which hosts my site. My ISP says they don't know the extensions .frm .myd and myi. They say I need a text file of my database to upload. How do I create a text file and why cannot the linux server read the extensions? Is it because they were created on a windows machine?
View Replies !
Upload File Contents To Database Using C API
What I am trying to do is to take the contents of a very large text file and place it into a LONGTEXT field in a database. I am looking for a solution using the C API to help me handle this. The code I use right now is very ineffecient. I basically use a VERY large character array that is like 600,000 characters long and store an UPDATE query to the database in this. I place the contents of the file being uploaded into this query where I SET the LONGTEXT field to the file contents. I know there has to be a much better way of handling this, so if you have any ideas, please let me know.
View Replies !
XLS/CSV Data Need To Upload MYSQL Database
I want to upload XLS/CSV huge data (90,000 rows in a XLS/CSV file) into MYSQL database. I want to use only Import option of phpmyadmin to upload XLS/CSV files. How can i to do/proceed such task using this graphical interface (without php script).
View Replies !
How To Upload Image Into Mysql Database
how to upload image into mysql database. my insert.php can move the uploaded images into upload directory(public_html/Upload). Now how can I have the SQL statement to insert the images from upload directory into the bob field ? I use the sql statement: Code:
View Replies !
How Can I Upload My Database From Local Pc To Server
I got a problem when I tried to upload MYSQL database. I don't have any idea how to upload it. It is my first time to do it. I already upload the pages from my local pc to server with Bulletproof FTP transfer and now I want to upload my database. For now I am using vertrigoServ 2.15 and I found my database in folder path C:Program FilesVertrigoServ2Mysqldatamydatabase. And I want it to transfer to my server. Do I need to install special software to fix my problem? Do I need to install MYSQL and php5 to my server? If there is any one who can give me detailed information, please make it clear and more detail b/se I don't have any idea how to upload database.
View Replies !
Upload A MySQL Database To Server
I need to upload a mySQL database at least once a week to a commercial ISP, which means that I DON'T have access to their mySQL databases directly; i.e., I can't upload the actual mySQL database file. What is the fastest method for uploading a mySQL database in this environment.
View Replies !
Upload Mp3 File And Info Into Database
I decided to create a directory on my server to store the mp3 files instead and then to store the files path in the mysql so I would first create the table like this $sql = CREATE TABLE mp3_files ( id int NOT NULL AUTO_INCREMENT Primary Key, Song Name VARCHAR, Artist Artist VARCHAR , Release_Date date, Additional Notes VARCHAR, Path ?? ); where "Path" would it me VARCHAR type?? and how would I store the absolute path of the file using PHP Lets say I had a folder called MP3_Files on my server that would contain all my mp3 files and I uploaded an mp3 song called big poppa? How would I store this location so that when
View Replies !
Beginner: How Do I Upload A .sql File To My Database?
I searched about the forum for this, but it only came up with issues of people have problems with uploading a database through phpMyAdmin that was too large. I don't have this problem (I don't think, the file is 7,000 KB), my problem is, I am completely lost in this area. The instruction for the files I have read as: 'Upload the database database.sql to the mysql database.' I presume I use phpMyAdmin for this? So I log into it, I have my fresh database created, I have all my details, dbname dbpass etc at hand... ha... now what? Do I have to upload the .sql file to my webspace through my FTP? Do I need a command line to type into the phpMyAdmin thing? Something else? Anything I have ever used previously, such a forums auto-created the databases for me or did whatever it needed to!
View Replies !
Upload A Large Database To A New Server?
I have been developing a web app on my local server and i am now trying to import a large database (1.7million rows) to the production server. i have exported it using phpmyadmin, no worries but i can only upload a tiny 8mb to the productions server (hosted with one and one). i emailed them but changing php.ini or .htaccess files doesnt help as the database is hosted on a different server to the php files to which i have access.I considered writing a script to step through the rows on my localhost and post them like form data to the new site, then writing a script to insert them from the new server, but with 1. 7 million rows, this will take forever, and i'm not entirely confident about this idea at all.
View Replies !
Upload And Fetch Images From MySQL Database
I want to upload nearly 10 million small images pertaining to some database into a mySQL database. Is there any way I can do this using Shell Scripts. Subsequently, I want to fetch the records based on specific conditions using a web based form. The images are in tiff format. Can someone pls help? The table structure would be : ID_Number -- varchar(10) SIgn_Image -- ?? (less than 50 KB).
View Replies !
Can I Upload A MYSQL Database To My Free Web Hosting Space?
I have a domain with awardspace.com which has php and MYSQL enabled. I am a newbie and not quite sure how to set it all up or if it's even possible with the Database I've created on my desktop. When I go to the Database Manager in the administrator section it has a spot to create a database,and confirm a password. From there I take it you would use the PHPMyAdmin to alter the database. Can I just upload a database using an FTP manager like Dreamweaver, or do I need to start from scratch and create the database on this server. If so is there a way to eventually download it so I don't lose any of the information in it.
View Replies !
MySQL And Wordpress
I've been running my WordPress blog for awhile on the WordPress site. Recently I noticed that now my Earthlink provider will host WordPress on my site, so I could either move my blog there or to my husband's Linux machine (we're both trying to learn PHP and MySQL. So anyway, I was going to try setting up WordPress on my Earthlink host but it needs me to create a MySQL database before I can set up WordPress. I was going to try setting one up, but I'm not dolphin-safe yet. Can you point me to a good book or online tutorial? The ones in the sticky are a bit too much for me yet.
View Replies !
WordPress Query
I have been working on some radical concepts for my blog (which is WordPress), one of which is to place the most recently commented on post at the top of the heap (the Loop). So... I set about writing some WordPress functionality (in the form of a plugin) and I've successfully gotten the ID numbers of the posts I want in the order I want them. But that is before WordPress gets its fingers on it and resorts the dataset by ID number (which basically sets things back to reverse chronological by post as opposed to reverse chronological by comment. Setting aside the fact that this is WordPress (and if you understand how WordPress works, feel free to chime in), I've decided to instead try to devise a custom query. These are the tables (for the WordPress challenged ): CREATE TABLE wp2_posts ( ID bigint(20) unsigned NOT NULL auto_increment, post_author bigint(20) NOT NULL default Ɔ', post_date datetime NOT NULL default ��-00-00 00:00:00', post_date_gmt datetime NOT NULL default ��-00-00 00:00:00', post_content longtext NOT NULL, post_title text NOT NULL, post_category int(4) NOT NULL default Ɔ', post_excerpt text NOT NULL, post_status enum('publish','draft','private','static','object','attachment','inherit','future') NOT NULL default 'publish', comment_status enum('open','closed','registered_only') NOT NULL default 'open', ping_status enum('open','closed') NOT NULL default 'open', post_password varchar(20) NOT NULL default '', post_name varchar(200) NOT NULL default '', to_ping text NOT NULL, pinged text NOT NULL, post_modified datetime NOT NULL default ��-00-00 00:00:00', post_modified_gmt datetime NOT NULL default ��-00-00 00:00:00', post_content_filtered text NOT NULL, post_parent bigint(20) NOT NULL default Ɔ', guid varchar(255) NOT NULL default '', menu_order int(11) NOT NULL default Ɔ', post_type varchar(20) NOT NULL default 'post', post_mime_type varchar(100) NOT NULL default '', comment_count bigint(20) NOT NULL default Ɔ', PRIMARY KEY (ID), KEY post_name (post_name), KEY type_status_date (post_type,post_status,post_date,ID), FULLTEXT KEY simplesearch (post_title,post_content), FULLTEXT KEY post_related (post_name,post_content) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1406 ; and CREATE TABLE wp2_comments ( comment_ID bigint(20) unsigned NOT NULL auto_increment, comment_post_ID int(11) NOT NULL default Ɔ', comment_author tinytext NOT NULL, comment_author_email varchar(100) NOT NULL default '', comment_author_url varchar(200) NOT NULL default '', comment_author_IP varchar(100) NOT NULL default '', comment_date datetime NOT NULL default ��-00-00 00:00:00', comment_date_gmt datetime NOT NULL default ��-00-00 00:00:00', comment_content text NOT NULL, comment_karma int(11) NOT NULL default Ɔ', comment_approved enum(Ɔ',Ƈ','spam') NOT NULL default Ƈ', comment_agent varchar(255) NOT NULL default '', comment_type varchar(20) NOT NULL default '', comment_parent bigint(20) NOT NULL default Ɔ', user_id bigint(20) NOT NULL default Ɔ', comment_subscribe enum('Y','N') NOT NULL default 'N', comment_favicon_url text NOT NULL, PRIMARY KEY (comment_ID), KEY comment_approved (comment_approved), KEY comment_post_ID (comment_post_ID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10736 ; Now I've started with this: SELECT DISTINCT ( ID ) AS mainid, wp2_posts. * , comment_date FROM wp2_posts LEFT JOIN wp2_comments ON wp2_posts.ID = wp2_comments.comment_post_id WHERE comment_approved = Ƈ' GROUP BY comment_date ORDER BY comment_date DESC I'm not really sure that this is what I want to do though. Can a database expert help me here. I really don't want the DISTINCT but it seems to be the only way to get unique entries. Otherwise I'll have 3 of one entry in a row then a fourth later on and so on. If I can simply return the results in order of comment_date DESC and limit the results to one instance of each entry that would be groovy.
View Replies !
Populate A Db Into Wordpress
I have a database containing about 89758 record . Here is the example of the record . Structure Code: CREATE TABLE IF NOT EXISTS `plants` ( `id` int(10) NOT NULL default '0', `symbol` varchar(255) NOT NULL default '', `scientific` varchar(255) NOT NULL default '', `common` varchar(255) NOT NULL default '', `family` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) Code: INSERT INTO `plants` VALUES (1, 'ABELI', 'Abelia R. Br.', 'abelia', 'Caprifoliaceae'); 1) I want to arrange the symbol in alphabetical order . 2) I want to populate / insert into wordpress database so that i can make a website
View Replies !
Wordpress Installation
I was using Fantastico in Cpanel to install Wordpress. I did the first step (filled out user, password, default folder, etc.). Then, when I got to the second step where it would create the database, I stopped. Got started on something else. When I went back and tried to install it again, it gave an error. So, I deleted all of the files and folders (except for the cgi-bin folder) in the root folder and tried to install it again via Fantastico. Still get the same error. Then went into Fantasico, hit Wordpress, and removed the "unknown" installation that it had listed. Tried to install again and stil got the same error: Here's the error I'm getting: The installation can not be completed: - You cannot install more than one script in the root directory of a domain. Suggestions? I looked in MyPHPAdmin, and there is still a db in there with 10 tables, and it is definitely for the WP installation. Should I delete it? If so, how?
View Replies !
MySQL Limitations For Wordpress
Wordpress v1.5x has the ability to have multiple blogs in a single database. The changes are made in the wp-config.php file. The plan is to designate one "central" install of WP and use it’s MySQL database to power the WP installs on many sites. My concern is how robust is MySQL? Will the "central" MySQL database eventually break as I create multiple of WP installs across many domains? Also, will calls to the central database make my pages load significantly slower. One last question, in the wp-config.php file you are asked to type in the host of database. Normally this is left at the default setting of "localhost". Under a central database installation, is the host name changed to the domain name where the MySQL database for WP is created?
View Replies !
MySQL Problem With Wordpress 2.1
I get the following error on my Word Press 2.1 installation: WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1] SELECT cat_id, cat_name FROM Its where my links (blogroll) are on the right side of the page. Any clue as to what it means and how I can fix it?
View Replies !
MySql For WordPress Import Error
i am having problems importing wordpress mysql database. I am helping my fren to host his site on my server however his mysql version was 4.1.21 but my server is 4.0.27. My host doesnt want to upgrade the mysql for now so I am pretty stuck now because I keep getting this error. CREATE TABLE `sk2_blacklist` ( `id` int ( 11 ) NOT NULL AUTO_INCREMENT , `type` tinytext NOT NULL , `value` text NOT NULL , `score` int( 11 ) NOT NULL default Ɔ', `trust` int( 11 ) NOT NULL default Ɔ' , `comments` text NOT NULL , `added` datetime NOT NULL default ��-00-00 00:00:00', `added_by` tinytext NOT NULL , `last_used` datetime NOT NULL default ��-00-00 00:00:00' , `used_count` int( 11 ) NOT NULL default Ɔ' , `user_reviewed` enum ( 'yes', 'no' ) NOT NULL default 'no', PRIMARY KEY ( `id` ) ) ENGINE = MYISAM AUTO_INCREMENT =225 DEFAULT CHARSET = latin1 ; MySQL said: #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 14 Is there away to solve this? or is there a converter to downgrade database? Worst comes to worse I will need to manually import each field.
View Replies !
Wordpress Auto Content Problem?
I'm trying to install a wordpress auto content updater. My wp-config.php file: <?php // ** MySQL settings ** // define('DB_NAME', 'vyskico_vyskidb'); // The name of the database define('DB_USER', 'vyskico_******'); // Your MySQL username define('DB_PASSWORD', '*********'); // ...and password define('DB_HOST', 'localhost'); // 99% chance you won't need to change this value define('DB_CHARSET', 'utf8'); define('DB_COLLATE', ''); // You can have multiple installations in one database if you give each a unique prefix $table_prefix = 'wp_' // Only numbers, letters, and underscores please! // Change this to localize WordPress. A corresponding MO file for the // chosen language must be installed to wp-content/languages. // For example, install de.mo to wp-content/languages and set WPLANG to 'de' // to enable German language support. define ('WPLANG', ''); /* That's all, stop editing! Happy blogging. */ define('ABSPATH', dirname(__FILE__).'/'); require_once(ABSPATH.'wp-settings.php'); ?> According to this, http://www.vyski.com/readme.htm, I should simply point the browser to http://www.vyski.com/rsstoblog1.php and it would install it. But it says "Table 'vyskico_vyskidb.wp_categories' doesn't exist". Then I checked phpmy admin: vyskico_vyskidb (11) * Vis wp_comments * Vis wp_links * Vis wp_options * Vis wp_postmeta * Vis wp_posts * Vis wp_rsstoblog * Vis wp_terms * Vis wp_term_relationships * Vis wp_term_taxonomy * Vis wp_usermeta * Vis wp_users It somehow wont create wp_categories, but it has installed wp_rsstoblog.
View Replies !
Ongoing Db Replacement Of Wordpress Site
We have a development and production site built on WordPress for a client with a bi-weekly release cycle. Every two weeks we plan to export the development database and overwrite the production files. Are there any precautions we should take to ensure a smooth transition or is it just as easy as restoring the database file?
View Replies !
Input Japense Text Characters In WordPress
PHP Code: define('DB_CHARSET', 'utf8'); define('DB_COLLATE', ''); but then I'm given this: Code: Warning: Cannot modify header information - headers already sent by (output started at /home/vn2007/public_html/moe/wp-config.php:54) in /home/vn2007/public_html/moe/wp-includes/pluggable.php on line 694
View Replies !
Cannot Upload
I am uploading Excel.csv to mySQL using phpMyAdmin. I've done it many times before with no problems. Got a single table with 18 columns and 137 rows. One of those columns has quite a bit of HTML in it to create a particular table for each of the 137 item. The table data uploads EXCEPT for one column ... it's a price column. Simple 2 decimal prices. I cannot get that column to upload? The only other time I had a similar problem was with a date column. That was a date format issue that I fixed without a problem.
View Replies !
How Do I Upload?
I need to know how I upload files of any kind on the server. Also how can i install files on the server. * a JPG you want to put in one cell of one row? (I already know what JPG is) * XML structure with data? (I don't know what XML is) * a csv file used to populate lots of rows? (I don't know what CSV is)
View Replies !
Binary Upload
i like to upload blob-data to MySQl database with this command: insert into files (f_name, f_binary, f_date, t_id) values ('musik2', LOAD_FILE('C:/Dokumente und Einstellungen/wolfgang.RE-MSQDW1NI9MBG/data/Neuer Ordner/a.mp3'), 2004-12-12, 1) MySQl states Error: 1048 Column 'f_binary' can not be null As I wasn't able to figure out my mistake in the commmand I created a txt-file a a.txt and doing the same command with this file - and this works.
View Replies !
Upload 50 MB Db Script
I have exported DB script from MySQL database. Its size is 50 MB. Now I want to upload this script data into another MySQL databse. But It gives me time execution error when I try to upload through PHPMyAdmin web interface.
View Replies !
Upload SQL File
I bought a database from a friend, he given me a SQL extenstion file and he said just go to your database and Import it. But in my Mysql PHP Myadmin there is not import function what i will do now?
View Replies !
Upload Images
I am completely new to MySQL and have no idea how it works. I want to be able to have an upload form so people can upload images to a MySQL database I have some script running on. How would I code that and also regulate so it resizes to a specific size when I call it up to show on a "results page"? Also, I have noticed that the fields that I have in the database seem to be all "required". If I don't input ALL of the fields then nothing is inputted into the database. However, if I do fill out all of the fields in the database then everything is uploaded correctly.What do I have to do in Myphp... to change it so no all of the fields are mandated to allow data entry? Also, I noticed that all of the fields are "NULL" if that means anything.
View Replies !
Upload Datafiles
is there somewhere an option i can increase the limit of 8,192KB per file upload on the SQL import datafile form ? I saw on many places they have up to 48k
View Replies !
Upload Backup
I am trying to back up my database via phpMyAdmin. I exported the data with no problem to a SQL file. However I am having problems uploading it to the new database. Since the file is large I first uploaded it to my server in a directory that the $cfg['uploadDIr'] parameter in the config.inc.php file is looking in. In phpMyAdmin I then click on the SQL tab and under the 'web server upload directory' I select the file and hit the 'Go' button. However after a short while I receive the error message "error 500: Internal Server Error - The server encountered an unexpected condition which prevented it from fulfilling the request." It does work if I upload a small file, but I get the error message when I upload a large file. Any idea why I can't upload a larger file (which is only 930KB)?
View Replies !
Fastest Way To Upload
i have to upload 12M records to a MySQL database. What is the fastest way -- like 20000 per second? I mean if source is a flat file? or if source is a remote db? or if source is a single table only from a different schema??
View Replies !
> 8 Hrs To Upload Data
a brief description of my situation : 1. Have a table with 23 odd fields. During table creation, I declared a 6 key combination primary key. 2. To upload 1.2 million records, I used "LOAD DATA INFILE...etc." & specified the target for the "LOAD INFILE..." statement as my text file which has the 1.2 mil. records. 3. I have waited for more than 8 hrs & the thread is still 'inserting' records into the table! I used SHOW PROCESSLIST to check what the thread is doing.. 4. The data is plain & simple VARCHARS & a bunch of DECIMAL types My queries - 1. Is 8-10 hrs reqd to upload a million records? If not, what am I doing wrong? 2. Should I drop the primary key constraint--> upload the records--> create the constraint again? Will this make the upload faster?why?
View Replies !
Image Upload
The basic question: What field do I use in MySQL to store images? Is it varchar? My second question: I'm using Dreamweaver MX to talk to my MySQL database using PHP. I can update records, add new records etc.. The only thing I can't figure out is how to create a browse option to look for a image to upload.
View Replies !
Upload Times
I need to upload 2 star catalogues to the mysql database. the first time i tried this i filled up the HD in 2 Days, my instructor mentioned that journalling was taking up most of the space and decided to remove-it. now, with journalling turned off, i have started re-uploading the catalogues, but have noticed a significant decrease in "write" speed. my question is, does journalling speed up writing data into mysql tables? i have roughly 180GB of data to upload, and it took me 4 days to upload 3GB's when last time it took me this time to upload 100GB.
View Replies !
Upload Form
I am trying to use this code to insert the file into my dba but am not sure if it works i get errors. I want to create a table, then put the file into the table using a web baised form. If anyone knows how i can create a form to do this or if anyone knows of documentation on how to do this i would be greatful. Below is my code <? if(isset($_POST['upload'])) { $fileName = $_FILES['userfile']['name']; $tmpName = $_FILES['userfile']['tmp_name']; $fileSize = $_FILES['userfile']['size']; $fileType = $_FILES['userfile']['type']; $fp = fopen($tmpName, 'r+'); $content = fwrite($fp, $fileSize); $content = fread($fp, $fileSize); $content = addslashes($content); fclose($fp); if(!get_magic_quotes_gpc()) { $fileName = addslashes($fileName); } include 'library/config.php'; include 'library/opendb.php'; // add a table to the selected database $result="CREATE TABLE userfile (fileName VARCHAR(25), fileSize VARCHAR(25), fileType VARCHAR(15), fileSize VARCHAR(2000))"; if (mysql_query($result)){ echo "success in table creation."; } else { echo "no table created."; } $query = "INSERT INTO upload (name, size, type, content ) ". "VALUES ('$fileName', '$fileSize', '$fileType', '$content')"; mysql_query($query) or die('Error, query failed'); include 'library/closedb.php'; echo "<br>File $fileName uploaded<br>"; } ?> <form action="" method="post" enctype="multipart/form-data" name="uploadform"> <table width="350" border="0" cellpadding="1" cellspacing="1" class="box"> <tr> <td width="246"><input type="hidden" name="MAX_FILE_SIZE" value="2000000"><input name="userfile" type="file" class="box" id="userfile"> </td> <td width="80"><input name="upload" type="submit" class="box" id="upload" value=" Upload "></td> </tr> </table> </form>
View Replies !
How To Upload MYSQL To Webserver
I have made several website using MS Access and asp. Now I need to upgrade from Accesss to MYSQL - I got my website working with MYSQL on my local PC - but now the problem is how I get it working on my webhost . I have the right connecting string ( according to webhotels supporter) but how do I transfer my SQL database from local pc to server..?? With MS Access it was very straight forward - I just uploaded my .MDB file to my DB folder om the server. How does this work with MYSQL - on the local pc my tables are stored in C:mysqldata est What I did was - uploading the folder 'test' (including the tables .FRM files ) to my BD folder on the webserver . But I cant make it work - There is no database called 'test' showed at the webhotel ...
View Replies !
|
TRACKER
