out of 31 tables in the database two wont be deploy or created only 29 does

@Tray2 I already created a database I'm just uploading the tables

@Danny971 and you are calling that one test_db ?

@Tray2 yes

@Danny971 And you have created those to tables? If not try creating them manually then import the data.

@Tray2 I created the tables on my local machine with phpmyadmin and mysql workbench. I exported the database from phpmyadmin and then uploaded the .sql file to compute engine

@Tray2 you mean like create them from the sql command line on the cloud

@Danny971 yes

@Tray2 I could try but I'm trying to understand why they were not created

@Danny971 Then I suggest you read the SQL in the file

@Tray2 I did that and it's like any other normal table that was deployed

@Danny971 and they all use the test_db schema?

@Tray2 yes do you want to do a team viewer or zoom session with me so I can explain it better maybe you will understand better

@Danny971 It's you who don't understand, if the database tells you the table doesn't exist, it doesn't exist, as to why it doesn't exist is anyones guess as long as you don't share the SQL that you have dumped.

I recommend creating proper migration files and seeders instead of exporting and importing from the command line.

@Tray2 I will upload the code here . The two that doesn't work and at Keats two that works from the .sql file

@Tray2 here is the code that creates the client_data in the my_db.sql

-- --------------------------------------------------------

--
-- Table structure for table `client_data`
--

CREATE TABLE `client_data` (
  `id` int(11) NOT NULL,
  `family_id` int(11) NOT NULL,
  `client_file` blob NOT NULL,
  `created_at` date NOT NULL DEFAULT current_timestamp(),
  `updated_at` date NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `client_data`
--

and also here is for backorder 

--
-- Table structure for table `backorder`
--

CREATE TABLE `backorder` (
  `id` int(11) NOT NULL,
  `family_id` int(11) NOT NULL,
  `product_name` varchar(40) NOT NULL,
  `qty` int(11) NOT NULL,
  `product_description` text NOT NULL,
  `product_category` varchar(20) NOT NULL,
  `created_at` date NOT NULL DEFAULT current_timestamp(),
  `updated_at` date NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

@Tray2 I gave you the code what do you think is wrong

@Danny971 What does the other create table statements look like?

@Tray2 same as the above two but different names and different column names

@Danny971 You need to show code, or we will not be able to help you.

@Tray2 code of the tables that work and successfully created and deployed?

@Danny971 The whole file would be preferable.

@Tray2 I don't feel comfortable posting it here how about we set a zoom or TeamViewer session ?

@Danny971

I suggest that you take a look in your script to make sure that you create all tables before trying to insert any data into the tables.

DDL first and then DMl.

@Tray2 that's the way I did it I created the tables first and then insert later

@Danny971 Well you must have fucked up somewhere...

Why don't you use mysqldump instead

https://www.digitalocean.com/community/tutorials/how-to-import-and-export-databases-in-mysql-or-mariadb

@Tray2 let's run a zoom session

@Tray2 i tried the link but no luck

@Tray2 i went on a re create the table from the mysql command line