View Single Post
  #4  
Old 12-29-2025, 03:44 AM
thechorus
Fire Beetle
 
Join Date: May 2018
Location: San Antonio, Texas US
Posts: 2
Default Cut And Pasting Does Not Work

The code above throws an error for me when I try to add it into my database.

I cut and pasted the above into a file named: bot_tables.sql.

When I try to import it, I get this:

Code:
eqemu@ffxiserver:~/Storage$ mysql -u eqemu -p peqdb < ./bot_tables.sql
mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
Enter password:
--------------
DROP TABLE IF EXISTS `bot_data`
--------------

ERROR 1451 (23000) at line 194: Cannot delete or update a parent row: a foreign key constraint fails
Reply With Quote