Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › PowerStore › Powerstore General / Announcements › Fill in database with products

Fill in database with products

Thread began 9/05/2009 1:06 am by andre.mercado338900 | Last modified 9/08/2009 2:44 pm by andre.mercado338900 | 1408 views | 1 replies

9/08/2009 2:44 pmEric Mittman

There are a couple of ways you can do this. The first is to use the LOAD DATA INFILE statement. This is how you do the importing directly into the db using SQL. There is a command line client tool that helps with this from MySQL called MySQL Import, here is a link to it:

mysqlimport.html

You can also do this completely with some other third party tool, there are many out there. I think one of the most common is Navicat, but there are many others as well. I also found this link to an online utility that helps to do this:

mysqlimport.html

I don't know anything about this site or the app that it has in regards to security or privacy but it seems to be used a bit.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.