I’m brand new to DH and trying out everything. One of the things from my old site is an existing MySQL database. I saved a dump of the whole database (not that big), which I uploaded to my server. I created the database with the following information:
DB name: jpdeni_genealogy
DB hostname: jpd-gen.jpdeni.com
DB username: jpdeni_deni
DB password: xxxxx (I’m not going to tell!
In the Knowledge base here, it says to use the following from within the shell to insert a database:
mysqlimport -L -hHOSTNAME -uUSER -pPASSWORD DATABASE DUMPED_TEXTFILE
I went to the shell and entered
mysqlimport -L -hjpd-gen.jpdeni.com -ujpdeni_deni -pxxxxx jpdeni_genealogy /home/jpdenico/jpdeni.com/jpdeni_genealogy.sql
I got the following error:
Error: Table ‘jpdeni_genealogy.jpdeni_genealogy’ doesn’t exist, when using table: jpdeni_genealogy
The text file has the information for creating the table (there’s only one in this database). The name of the database is “jpdeni_genealogy”. The name of the table is supposed to be “stories”.
What am I doing wrong?