Archive Pages Design$type=blogging

How to import large database file in mac

  • IMPORT DATABASE INTO MAMP

    Step One:
    • Open a new terminal window
    • CAREFUL: This will replace all tables in the database you specify!
    Step Two:
    • /applications/MAMP/library/bin/mysql -u [USERNAME] -p [DATABASE_NAME] < [PATH_TO_SQL_FILE]
    • Hit the Enter Key
    • Example:
    • /applications/MAMP/library/bin/mysql -u root -p wordpress_db < /Applications/MAMP/htdocs/backupDB.sql
    • Quick Tip: Don’t forget that you can simply drag the file into the terminal window and it will enter the location of the file for you.
    Step Three:
    • You should be prompted with the following line:
    • Enter password:
    • Type your password, keep in mind that the letters will not appear, but they are there
    • Hit the enter key
    Step Four:
    • Check if you database was successfully imported
    • Navigate to phpMyAdmin in a browser
    • http://localhost:8888/MAMP/
Name

MAMP movies MYSQL MySQL Interview Questions news php PHP Interview Questions React React Advaced Questions reviews slider Top 50 React Interview Questions Tutorial tutorials UFW
false
ltr
item
CodeVizz: How to import large database file in mac
How to import large database file in mac
CodeVizz
https://www.codevizz.com/2018/10/how-to-import-large-database-file-in-mac.html
https://www.codevizz.com/
https://www.codevizz.com/
https://www.codevizz.com/2018/10/how-to-import-large-database-file-in-mac.html
true
3366176187658761010
UTF-8
Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago