0

I have mysql table named session i want to restore it from smith.sql file to database name smith

From my linux box i run mysql command to restore the whole databae 

# mysql smith < smith.sql

How could i restore session table only ?

iLinux85
  • 403
  • 2
  • 6
  • 20
  • You will need to select the part of smith.sql which creates and restores the session table only. It would help if you post smith.sql – krishnang Sep 13 '13 at 11:16

1 Answers1

-2

start->XAMPP control panel

then open your browser window --> type phpmyadmin select your database --> click on create table button then enter table name --> enter single default column name like id --> select int datatype --> then click save button.

now your table created sucessfully.

now do u want to restore old table data to new table data.

select newly created table --> then click on import button top of the screen --> browse your single table sql file --> select format option sql --> then click GO button.

thats it now u have all u r old table data in u r new table

enter link description here

user3090955
  • 1
  • 1
  • 1