importing data in MYsql

shakim · 07-31-2003, 08:11 PM

am new a MYSQL. I have been using Access. Now, I am converting to MYSQL. I got a tool that takes a Access file and converts it to a dump file call "filename.sql" Now how do I import that into MYSQL? After logging into mysql what should I do next and what is the command to import this file? Also, I tried using PHPMYadmin. Because this is a huge file (50,000 records) it times out. So is there a way I can adjust the time so it doesn't time out. I want to learn how to do this both ways. via the command line and via phpmyadmin. thanx. Am example of the command line would be great.

I log into mysql, I get this promt "MYSQL>" Now what do I type? My data file is located at "c:/data.sql"

adam_uk · 07-31-2003, 11:10 PM

find a utility to split files up split the file up so each segment is just under a meg each

then execute them in phpmyadmin

i had to restore a phpbb forum and i had to break the file up and a meg of sql query is handled fine by phpmyadmin

deadserious · 08-01-2003, 01:13 AM

Quote:

Originally posted by shakim

I log into mysql, I get this promt "MYSQL>" Now what do I type? My data file is located at "c:/data.sql"

Code:

cd c:mysqlbin
mysql -uSqlUser -p DBNAME < c:data.sql

That should work.

shakim · 08-01-2003, 01:28 PM

My MYSQL is located on a server not on my local machine. Will that make a difference. Because I log into mysql via telnet.

deadserious · 08-01-2003, 02:16 PM

It should be just the same.

You can also do it without changing to the mysql directory:

Code:

c:pathtomysql -uSqlUser -p DBNAME < c:data.sql

You used a forward slash above, but I figured it would actually be a backslash since you're on a windows machine, but if you're logging into a server it may be forward slash. Just make sure you have the paths right and it should all work the same as long as you have permission to run it.

shakim · 08-01-2003, 03:39 PM

Just ot be clear.

My MYSQL is running on a server. And my data file is located on my local machine.

1. I log into the server using telnet.
2. I am at the $ promt.
3. Type "mysql -uSqlUser -p DBNAME < c:data.sql"

I don't need to ftp the data.sql file to the server first!

deadserious · 08-01-2003, 03:46 PM

Yes you need the file to be on the same server first.

07-31-2003, 08:11 PM	#1 (permalink)
shakim New Member Join Date: May 2003 Posts: 19 31.00 NP$ (Donate)	importing data in MYsql am new a MYSQL. I have been using Access. Now, I am converting to MYSQL. I got a tool that takes a Access file and converts it to a dump file call "filename.sql" Now how do I import that into MYSQL? After logging into mysql what should I do next and what is the command to import this file? Also, I tried using PHPMYadmin. Because this is a huge file (50,000 records) it times out. So is there a way I can adjust the time so it doesn't time out. I want to learn how to do this both ways. via the command line and via phpmyadmin. thanx. Am example of the command line would be great. I log into mysql, I get this promt "MYSQL>" Now what do I type? My data file is located at "c:/data.sql" __________________ "Knowledge Speaks and Wisdom Listens"

08-01-2003, 01:28 PM	#4 (permalink)
shakim New Member Join Date: May 2003 Posts: 19 31.00 NP$ (Donate)	My MYSQL is located on a server not on my local machine. Will that make a difference. Because I log into mysql via telnet. __________________ "Knowledge Speaks and Wisdom Listens"

08-01-2003, 02:16 PM	#5 (permalink)
deadserious Senior Member Join Date: Aug 2002 Posts: 1,300 2.85 NP$ (Donate)	It should be just the same. You can also do it without changing to the mysql directory: Code: c:pathtomysql -uSqlUser -p DBNAME < c:data.sql You used a forward slash above, but I figured it would actually be a backslash since you're on a windows machine, but if you're logging into a server it may be forward slash. Just make sure you have the paths right and it should all work the same as long as you have permission to run it.

08-01-2003, 03:39 PM	#6 (permalink)
shakim New Member Join Date: May 2003 Posts: 19 31.00 NP$ (Donate)	Just ot be clear. My MYSQL is running on a server. And my data file is located on my local machine. 1. I log into the server using telnet. 2. I am at the $ promt. 3. Type "mysql -uSqlUser -p DBNAME < c:data.sql" I don't need to ftp the data.sql file to the server first! __________________ "Knowledge Speaks and Wisdom Listens"

07-31-2003, 11:10 PM	#2 (permalink)
adam_uk Senior Member Join Date: May 2003 Posts: 2,211 6,170.25 NP$ (Donate)	find a utility to split files up split the file up so each segment is just under a meg each then execute them in phpmyadmin i had to restore a phpbb forum and i had to break the file up and a meg of sql query is handled fine by phpmyadmin

08-01-2003, 03:46 PM	#7 (permalink)
deadserious Senior Member Join Date: Aug 2002 Posts: 1,300 2.85 NP$ (Donate)	Yes you need the file to be on the same server first.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)