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 Complete Forum Thread with Replies
Related Forum Messages:
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 !
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 !
Database Beginner Question - Many To Many Relationships
I'm fairly new to databases and i was wondering how to store many-to-many relationships with php and mysql (but i think this is a general database question). For example: in a cms for a blog i have a blog table which stores all blog info including id. However, i want my blog posts to be able to belong to more than one category. so, i have another table which stores each category with id and another which should store blog id and category id for each category for each blog. However, when the php script makes a database entry, it doesn't know what the id for the blog will be because it is automatically generated with AUTO_INCREMENT. I'm guessing that the only way would be to specify the id, but then how to know what id to specify? I like the simplicity of using AUTO_INCREMENT but i need to be able to specify multiple categories.
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 .mdb Access File
I'd be using DTS for this whole process. I'm glad to have to learn to do it with mySQL though.I have an Access .mdb file, that I need to upload from my local machine to our hosted mySQL site via BlueHost.I'll be using phpMyAdmin. It looks like the only way is to import into an existing table is from a text file.Are there any other ways to take the .mdb file and copy it up, and into the mySQL table?I got a converter tool, Access2MySQLPro 5, which has 10 trial conversions. Didn't know if anyone else has better ideas?
View Replies !
File Upload To MySql
I have a database with horse racing tips in it and the fields are Date, Time, Course, Horse, Odds in a table called Results. I currently upload the tips each day via phpmyadmin using a .csv file with the data in it.I want to have a page on my site where I can just upload the .csv file quickly each morning.If there a simple PHP script anyone knows of to do this?
View Replies !
Error When Trying Upload A .sql File
i get this message, when I try to upload a sql-File (Wikipedia FIle) (upload with phpMyAdmin) Error at the line 47: LOCK TABLES `cur` WRITE; Query: LOCK TABLES `cur` WRITE; MySQL: Access denied for user: 'web2@localhost' to database 'usr_web2_1' DO you have any solutions for?
View Replies !
Upload File Error
Warning: move_uploaded_file(http://www.grace4missions.com/sermons/mp3s/Amazing Grace.mid): failed to open stream: HTTP wrapper does not support writeable connections. in /home/grace4mi/public_html/sermons/admin/add.php on line 54 I am using PHP to upload a file through a form. Here is my php. What is the problem? $uploaddir = 'http://www.grace4missions.com/sermons/mp3s/' //if (move_uploaded_file($_FILES['mp3']['tmp_name'], $uploaddir . $_FILES['mp3']['name'])) { // print "File is valid, and was successfully uploaded. Here's some more debugging info: "; // print "Name:" . $_FILES['mp3']['name']; //} else { // print "Upload failed: "; // print_r($_FILES); // } move_uploaded_file($_FILES['mp3']['tmp_name'], $uploaddir . $_FILES['mp3']['name']); $filename = $_FILES['mp3']['name'];
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 !
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 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 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 !
Beginner To Mysql
I have worked with Oracle and i had a few questions regarding the syntax, in oracle we use the number(1) how is it when compared with mysql .I have seen that one can use int but could it be possible also to restrict the number of digits like int(1).I have tried this out n it does not seem to work.I would also like to know the the diff in varchar n varchar2() if it is the same as in oracle
View Replies !
Replication For A Complete Beginner!
I've set up a mysql server on a Windows XP machine. I need to set up a completely different server on the same machine so that I can work on getting replication.. ie. as I write to one DB, another on the other server gets updated too. Ive read the MYSQL manual but its geared towards UNIX and I just dont understand it to be honest! I know that I need to change a port number to get the 2nd server running completely separately, but other than that, Im not sure. Can anyone put it into plain English?
View Replies !
Beginner Development Process
Whats the best way to develop mySql database to live server? I've work for many years with Access file based database and development was pretty straight forward: 1. design, develop, and test database on local server. 2. after fully tested, ftp up to live server. When comes to mySql management system, I'm not sure how to proceed. I've downloaded and learned how to use the control center and admin interfaces. I've even taken tutorials working at the command line. While this is all good its still all local how the heck do i get it up to a live server. I've read you can use admin tool to dump the data out, but once you've done that what do you do with it? And once you have it up to the server how do you get it back to your machine to back it up or work on it?
View Replies !
MySQL/Perl Book Recommendation For A Beginner?
Here's the situation: I have a Perl-based forum that I wrote myself. It currently supports user accounts, but these are stored in a flat text file (as is everything else for that matter). I'm looking to convert this to a MySQL database so that I can do more with that information, but with less processing time (reading through that huge text file to find something isn't very efficient). In the future I hope to move the whole forum over to MySQL, but I thought a good starter project would be just one aspect of it. At this point I am looking for recommendations on good books for someone moderately experienced with Perl, but who has NO experience with MySQL or anything similar. Since I'd prefer to integrate this with my existing script, I'd rather stick with Perl and not learn PHP at this time. So far it seems like "MySQL and Perl for the Web" is a good - are there others? I prefer reference-style texts with useful code examples, rather than lesson-style books.
View Replies !
Access Denied For User 'root'@'localhost' (was "help!!! Just A Beginner..")
Hello i recently installed WAMP5 to handle my phpmysqlapache localhost sever. but when i go to the control panel and clicked the localhost and phpmyadmin everything seems fine because i can see the phpinfo window and also the phpmyadmin.. but not when i clicked the SQLite Manager.Unable to connect to database manager. Could not connect: Access denied for user 'root'@'localhost' (using password: YES).
View Replies !
Tar File For Database
i have a large .tar file (1.3 gigs) that i want to import into a mysql database. database is at a remote hosting service. the file is made up of text and script to make database tables etc. i really don't know how to deal with tar files. will i need to use putty to open and separate files? or do i import the whole thing and mysql takes care of it? this is a tar file not a zipped tar.gz file.
View Replies !
.sql Database File
i tried to instal the .sql data_base_ file that is supplied with some demo content for a joomla business template and it just says this - Error SQL query: -- phpMyAdmin SQL Dump -- version 2.10.1 -- http://www.phpmyadmin.net -- -- Host: sql.systemvista.nazwa.pl -- Czas wygenerowania: 13 Cze 2007, 19:01 -- Wersja serwera: 4.1.22 -- Wersja PHP: 4.4.7 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; MySQL said: Documentation #1193 - Unknown system variable 'SQL_MODE'
View Replies !
Database File On Usb HD
I have been given the job of setting up a family website, and I have a USB2 hard disk that will be plugged into a Linux server running apache/php/mysql etc. When running the website, I want to use mambo for ease of use and for the components and stuff that you can get. I am looking to keep as much of the website stored on the USB disk, as then if I need to relocate the website I can do so with minimal problems. Is there any way that the mySQL server on the linux box can store the database on the USB HD, so that it can be loaded into another server if it is relocated, and so that it dosen't get mixed up with existing databases on the server.
View Replies !
File Database
I am trying to design a db that users can download files from. In simple terms a user is going to search for a picture and then according to the name of the pic the link to download is going to pop-up.I am working with PHP and mysql. Does anybody have any idea how I can implement this?
View Replies !
Database File Size
I running MySQL locally and have the following dir setup C:wampmysqldatamike - This is where the tables for the database mike are stored C:wampmysqldata - This is where I think the database data is stored. Basically the file in the data dir. (ibdata1) is 10,240kb in size. When I update a table in the mike database the file size of ibdata1 doesn't increase and I don't know why?
View Replies !
Convert CSV File To SQL Database
i have this existing table of four columns and about 64 thousand rows as a csv file. is there a way i can convert these comma separated values to a valid mysql database without spending a fortune.
View Replies !
Open A File In The Database
i would like to load data in my database from a file and i do: mysql> SOURCE "C:Documents and SettingsuserDesktopcreate_sql.txt"; ERROR: Failed to open file '"C:Documents and SettingsuserDesktopcreate_s ql.txt"', error: 22 mysql> It's just that i would like to create a table using a file.The file already consists of statements like : create table Store(sid integer, address varchar(20), eid integer, name varchar(20), primary key (sid)); What am i supposed to do in order to create tables using a file?
View Replies !
Saving Database To File
How would you go abouts saving all data in the mysql to a file and download it? I know how to retreive the data and write it (dont know how to make a download button) but how do i record the table data, such as make them inserts like you would in phpmyadmin. Then with a click of the button in mysqlsave.php, it retrieves the information, saves it to mysqlDATA.doc and then downloads it to your hard drive?
View Replies !
Loading Database From .txt File, Please Help! Thanks
I'm very new to mysql and programming in general, just learning the basics, and currently I'm trying to access a database that was formerly on a different server and compressed into a large .txt file, and I also have a version of it in .tar . So the database is on my computer, and I'm just trying to view it through mysql on my machine, windows xp. I have tried the following: c:> "program filesmysqlinmysql.exe" -u root -ppassword < file.txt system unable to find the file I currently have the file in the 'database' folder I created in the mysql directory. should it be somewhere else? should I change its type through properties? If you have any suggestions for me could you please let me know.
View Replies !
Can Not Read My Database File *.frm
I have wamp server in my computer, i had some problem runing some of my file so i copied the database file from C:wampinmysqlmysql5.0.51adataitsal WHERE "ITSAL" IS THE NAME OF MY DATABASE and reinstall the wamp server, the problem now phpmydmin does not reconize these files which in this format: *.frm or if any body know of any software i can use to read the structure of files with extension *.frm
View Replies !
Exported Mysql Database With TMD File?
I've got an exported database from an external system. It's in the format of MYI, MYD and frm extension files. However, one table in this database has book.frm, book.MYD, book.MYI _AND_ book.TMD. When I've created a database in phpmyadmin/mysql, moved all the files into the proper directory, every table can be looked at and selected but this book table states that it's in use. When I try to browse it, it states that the book.MYI cant be opened!
View Replies !
Cannot Ceate Database From Text File...
CREATE DATABASE dealership; USE dealership; CREATE TABLE users ( requestid int(11) NOT NULL auto_increment, firstname varchar(20) default NULL, lastname varchar(20) default NULL, city varchar(25) default NULL, phone varchar(14) default NULL, email varchar(25) default NULL, username varchar(25) default NULL, password varchar(50) default NULL, PRIMARY KEY(requestid) ) Instruction 2 is to save the file as dealership.sql... Instruction 3 is to import dealership.sql into the MySQL engine using the following command: mysql < C:workfolderexerciseschapter 18dealership.sql
View Replies !
|
TRACKER
